[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):

 Add this index to your wp_posts table:

 (post_type, menu_order, post_title)

 And then use trunk. Not 2.7.1.

 Intuitively, there is a need for:

  - a new case in wp-admin/admin-ajax.php (e.g. quickfind) that tosses an
 empty array into a filter with a parameter (pages, in our case), so
 $results = apply_filters(quickfind, array(), pages)
  - some kind of function that returns the needed array using a db query
  - the needed UI functions in wp-admin/includes/template.php
  - possibly some edits to wp-admin/js/pages.dev.js (use the SCRIPT_DEBUG
 define to use that one)

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