handle thousands of pages

[hailin]

#

This isn't one issue, it's several, but they're related.

TRAC Ticket #5303 fixes hundreds of pages issue;
when there are thousands of pages, it is still very slow.

It might be -better-, but the scaling issues are present even in 2.5, and they're severe enough that it's grinding my WP install to a halt as I continue to import pages.

Now, to be clear, I have a -lot- of pages. My current test environment has just under 4000, so it takes quite some time to render all those out on one page.

It seems to me that the simplest solution is to rewrite edit-pages so that it paginates, the same way edit-posts does. Is there a reason that this hasn't been done already?

Similarly, if you edit any page (with thousands of pages in the DB), it will take a few minutes minute to render the page-editing screen. The bottleneck is the parent_dropdown function. As a hack, I've removed the box entirely from my page-editing screen (and in the meantime i can use the pageMash plugin if/when I want to change page parent/ordering), but this isn't a long-term solution. Obviously, the "page parent" interface box wasn't designed with this many pages in mind, and I'm going to think about a new design which scales well that I can write as a plugin (or a patch). Any thoughts you have are appreciated Posted: 2008-04-02 18:15:51 # #

josephscott Member

Having edit-pages support pagination has been brought up, but hasn't been tackled yet. I suspect the parent-child relationships for pages makes this harder to do that edit-posts.

I'll ramp up a test blog with many pages and see what options we have on making it better.

Just so I'm clear, the two places that this has been the biggest problem is "Manage -> Pages" and "Write -> Page" (page parent box), correct? Are there any other places where you've seen major problems? Posted: 2008-04-02 21:32:31 #

[hailin]

I will take a look.

[lloydbudd]

Relates to #2004

[randyhoyt]

I think the "Parent Page" option could handled in a dialog box, in much the same way the upload feature was moved off the page itself. The parent page isn't something that will change often, probably just the first time you create a page.

[randyhoyt]

I imagine the "Manage Pages" page isn't paginated because of their hierarchical nature; what if you got to the end of a page (say 20 records), but record #21 was a child of record #20? I don't think this is an impossible issue to overcome, but it will need to be considered.

[ramenboy]

Add paging to manage pages on WordPress 2.5

[ramenboy]

I have submitted a patch that adds paging support the "Manage Pages" page on WordPress 2.5. It queries only the fields necessary for display, rather than loading every page into memory like the current version does. If the first item on a page is not a root, its parents are prepended with "(continued)" in the title so that you don't lose your place in the hierarchy. "Manage Pages" loads in about 1-2 seconds now, where it used to take 10-20. We have about 500 pages.

[ryan]

(In [8089]) Add paging to Manage->Pages. see #6561

[jacobsantos]

This should be marked as fixed and not as worksforme.