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

 i gauge performance on whether my server crashes or not.  :D

 With the old patch, speed was great.  According to W3 total cache, initial
 page build time was 4 - 10 second max.  Although as scribu said above,
 there were segment faults which I learned to live with for the last year
 or so just for the performance gains.  Server loads were constant between
 1.5 - 3

 With the latest patches the segment faults seem to be fixed, but page
 build time goes as high 44 seconds and sometimes not all.  Server load is
 contantly at 8-10.

 Seriously considering splitting our site into two installs of wordpress.
 Only the last 50 posts get the majority of traffic, while the remaining
 75k are 4 years worth of archives.  Its insane that Wordpress has to go
 through all those 75k posts, to display data for these few 50.

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