[wp-trac] Re: [WordPress Trac] #2604: SQL Query Optimization

[WordPress Trac]

#2604: SQL Query Optimization
----------------------------+-----------------------------------------------
       Id:  2604            |      Status:  new                     
Component:  Administration  |    Modified:  Fri Mar 31 23:18:28 2006
 Severity:  normal          |   Milestone:  2.1                     
 Priority:  normal          |     Version:  2.0.2                   
    Owner:  ryan            |    Reporter:  ryan                    
----------------------------+-----------------------------------------------
Comment (by ryan):

 Removing DISTINCT from the main post query resulted in a 6% performance
 improvement over current trunk.  Benchmarked 500 requests using apache
 bench.  The exact same front page was used for each run.  Document length
 was 22205 bytes.  This is with the default theme and the default install
 options.  Imported the same 225 posts for each to prime the test with some
 realistic blog posts.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/2604>
WordPress Trac <http://wordpress.org/>
WordPress blogging software