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

 The last version of this patch, I applied 9 months ago worked beautifully.
 My MYSQL loads went way down on a site with 75,000 posts, 500,000 page
 views per day.

 Now I've had to upgrade to 3.2 and I completely forgot that I was running
 the patch.  (I'm not a website admin by trade, and i am learning all this
 as I go)

 I applied simple_modified.10964.diff and its not working as the old patch
 did.  Loads are still up and it spikes when editing or publishing a new
 post and when the homepage is being generated for a logged in user.

 Just wanted to give my experience with it and sorry i can't provide
 technical details you guys might need.

 So I guess I know I have to look back at the old patch and manually apply
 it.

 Thanks.

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