[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  |
-------------------------------------+-----------------------------

Comment (by JediSthlm):

 @scribu: Thanks for the reply, I applied the patch to my query.php and it
 seems to work kind of.  The site feels more snappier but I can see that my
 mysqld process is very high (100%). If I run mytop I see that there is a
 few "Query SELECT wp_posts.* FROM wp_posts JOIN wp_postmeta ON
 (wp_posts.ID = wp_postmeta....." and the same number of "Sleep" with the
 same time. The good thing (just tried a few minutes is that the server
 don't hang and I get an 502.

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