[wp-trac] [WordPress Trac] #6561: handle thousands of pages

[WordPress Trac]

#6561: handle thousands of pages
---------------------+------------------------------------------------------
 Reporter:  hailin   |       Owner:  anonymous
     Type:  defect   |      Status:  new      
 Priority:  normal   |   Milestone:  2.7      
Component:  General  |     Version:           
 Severity:  normal   |    Keywords:           
---------------------+------------------------------------------------------
 #

 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 #

-- 
Ticket URL: <http://trac.wordpress.org/ticket/6561>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software