[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:  2.9                     
Component:  Performance  |     Version:  2.8.4                   
 Severity:  normal       |    Keywords:  query_posts, performance
-------------------------+--------------------------------------------------

Comment(by scribu):

 Replying to [comment:6 buch0090]:
 > Not sure I'm following you concerning subquery, you would still do a
 select of all fields/all rows THEN do a subquery? This fix only has the
 post ID when selecting all rows...then a second query only selects from
 the IDs of the first query.

 I meant put the first query as a subquery of the second. That way, you
 don't have so much back-and-forth between the DB and PHP.

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