How Many Pages Is Too Many?

You might look into a pagination plugin for the admin screens, which will limit the number of pages presented in a list at one time.

I haven’t used the Enhanced View Plugin myself, so maybe it won’t solve your problem; but it’s worth trying.

Enhanced View only does Posts, not Pages otherwise it would be perfect. The author has given up trying to get it to work with Pages. Good idea though!

In the end I have reduced load time from a few minutes to 10 seconds (still too long!) by altering the page_rows function in admin-functions.php.

I commented out the line

if ($post->post_parent == $parent) {

and its corresponding }.

And also commented out this line:

page_rows($id, $level + 1, $pages);

immediately above the close curly brace in that loop.

The result is that pages that are “sub pages” of another page no longer show that they are sub pages (with preceding dashes) on the manage pages screen or display in the “right” place under the master page but it means that the page_rows routine is executed only 360 times not 12,960 times (360^2).

This function doesn’t seem to be called from anywhere apart from edit_pages() so I guess I am safe.

The moral is … don’t have subpages! It increases the number of loops of page_rows exponentially. I dread to think what happens if you have subsubpages (360^3 > 46 million)!

Follow up to this …

I upgraded my server from a PII-300 with 384MB RAM to a PIV-3.4GHz with 2GB RAM. This has obviously made everything much faster. This page still takes 3 seconds WITH my adjustment above and MORE than 30 seconds (but not much more) with the adjustment removed.

So really, anyone with more than about 100 pages must be seeing problems like this. Unless there’s something messed up in my config.

I’m sure that loop can be written vastly more efficiently (using a subquery on the initial SQL so that the pages are in the order you want to write them out in in the recordset?) That would make the pages at least 10 times faster – how do you submit a patch to wordpress?

How fast do the pages load if you disable all of your active plugins?

Patches can be filed at trac.www.remarpro.com. You’ll need to login with your support forum username.

Hi,

I realise this is an old topic but it still ranks highly for people looking for a solution to the timeouts experienced with a huge number of pages (i.e. using WordPress as a CMS)

I wrote a blog topic on the subject of speeding up the WordPress ‘Manage Pages’ admin page:

WordPress: Speed up ‘Manage Pages’ admin page

Hopefully it will be useful to other looking for a solution to this problem