[wp-trac] [WordPress Trac] #10964: Improving query_posts performance

[WordPress Trac]

#10964: Improving query_posts performance
-------------------------+--------------------------------------------------
 Reporter:  buch0090     |       Owner:           
     Type:  enhancement  |      Status:  new      
 Priority:  normal       |   Milestone:  3.1      
Component:  Performance  |     Version:  2.8.4    
 Severity:  normal       |    Keywords:  has-patch
-------------------------+--------------------------------------------------
Changes (by willmot):

  * keywords:  needs-patch => has-patch
  * milestone:  Future Release => 3.1


Comment:

 Attached patch fixes the $orderby issues by using the order of the ID's
 from the first query as the orderby in the second quick_request.

 This fixes previously mentioned issues with orderby meta_value and by
 extension ordering by a column from a table that was in the original join.
 I can't reproduce the other issue I was having taxonomy queries so perhaps
 that was caused by something else.

 Anyhow like @buch0090 we are running this on production on
 digitaltrends.com where it has significantly reduced the number of slow
 queries we get from uncached pages.

 Is there anyway this can be pulled back into the 3.0 release as it did
 have a patch before the deadline, its just that it needed tweaking?

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