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

 another potential option could be a simple index on (post_type,
 post_title) and an unordered query:

 select * from $wpdb->posts where post_type = page and post_title like foo%

 that *should* use the index as well, and it might be faster than the
 previous index. (string comparison functions conveniently happen to be
 case insensitive in mysql.)

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