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

 Thanks for your in-depth reply.

 I suppose the use case I am thinking of is when you have many pages (or
 custom post types) and you use a plugin like CMS Tree Page View or other
 plugin which allows you to set the order of posts by drag-n-drop. General
 these tend to set a different menu_order value for every post - is that
 what you mean above when you say "selective enough"?

 So that's fine if you have an average quantity of pages, but say you have
 loads of pages or an e-commerce store with thousands of products which
 users can order in a custom way by menu_order. In that instance would an
 index on menu_order be beneficial?

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