[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 Denis-de-Bernardy):

 php won't beat an index if one is used. especially if we're talking 3k
 page lists. that'll consume huge amounts of memory.

 an index on post_type, menu_order, post_title may do the trick, but at the
 end of the day it goes down to the amount of clutter that is present in
 the database. if the number of posts, revisions and attachments is small,
 and the query planner decides it's faster to seq scan the mess and sort it
 without an index, it will...

 anyway, see #9642

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