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

[WordPress Trac]

#9864: Performance issues with large number of pages
--------------------------+-----------------------------
 Reporter:  pp19dd        |       Owner:
     Type:  defect (bug)  |      Status:  assigned
 Priority:  normal        |   Milestone:  Future Release
Component:  Performance   |     Version:  2.7.1
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+-----------------------------

Comment (by husobj):

 Replying to [comment:5 Denis-de-Bernardy]:
 > 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...

 Is there any reason why 'menu_order' doesn't have an index?[[BR]]
 It strikes me the primary use for 'menu_order' would be to sort results so
 surely having an index on this would help?[[BR]]
 I'll caveat this by saying I'm no database expert :)

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