Hi,
I've got a PW site functioning as a contest administration interface in which each contest entry is a Page. I've just passed 10k entries, and am starting to see performance issues in a custom reporting page I built.
Here's how I get the first part of the data I need for the reporting page:
$totalUnpublished = $pages->find("template=entry,status=unpublished")->count();
$totalPublished = $pages->find("template=entry, parent!=/entries/rejected/")->count();
$totalRejected = $pages->find("template=entry,parent=/entries/rejected/,include=all")->count();
I can imagine these calls are using a lot of memory, so I checked into the memory_limit setting and it's set at the 5.3 default of 128M. I would have thought that would be enough, but... no.
Is there a way for me to lighten the load of the returned PageArrays to reduce memory usage?
Thanks.