[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:  Future Release
Component:  Performance              |     Version:  2.8.4
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |
-------------------------------------+-----------------------------
Changes (by asannad):

 * cc: asannad (added)


Comment:

 Attached( query.php_2012-01-05.patch ) is the patch against trunk that I
 have been using in our live site. I have used the idea(and older patches)
 of selecting the ids first and then getting all fields for those ids. The
 major problem is the write IO because of the temporary table thats getting
 created, attached is the graph( Write-IO-Graph.gif ) showing write IO with
 patch and without patch.

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