[wp-trac] Re: [WordPress Trac] #9864: Performance issues with large number of pages

[WordPress Trac]

#9864: Performance issues with large number of pages
--------------------------+-------------------------------------------------
 Reporter:  pp19dd        |       Owner:  Denis-de-Bernardy
     Type:  defect (bug)  |      Status:  new              
 Priority:  normal        |   Milestone:  Future Release   
Component:  Performance   |     Version:  2.7.1            
 Severity:  normal        |    Keywords:  2nd-opinion      
--------------------------+-------------------------------------------------

Comment(by pp19dd):

 Thanks. I was unable to find related tickets, but thanks to the references
 I see this is being looked at.  I added an index to the suggested fields
 and in this case it really made no difference.

 The question that I have is -- why would we want to list all 5,000+ pages
 in a dropdown on the 'edit page' screen?  It would seem prudent to put up
 a paginated search widget there.  I mean, its purpose is to assign a
 parent to the page.

 I don't think this is a question of optimization as much as "why are we
 querying this at all?" (page_edit_eyesore.png shows a dropdown that's had
 its scroll bar pushed off the screen - but - more importantly it shows the
 entire 5,000 page listing.)

 At any rate, I think that you might have covered this under another patch.
 I will keep looking around for an upcoming solution - otherwise - I'll
 manually disable that admin feature.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/9864#comment:6>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software