I am developing on a high performance MediaTemple DV at the moment. The RAM on the server is 16GB and while pages load relatively quickly, it appears that any scripts I write which use the Channel Entries API, or in fact any channel entries loops that I include, whether they be directly embedded in the template, or called via ajax, tend to max out the CPU. For example, calling a couple of hundred channel entries, with each entry consisting of less than 40 fairly standard fields (with the exception of a small few specific items), set the CPU on the server to be over 100%. Has anyone else experienced a similar issue with channels, entries, the API itself, etc? Our system relies very heavily on calling and filtering channel entries so the current performance is definitely unacceptable.
Any input would be greatly appreciated.