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

[WordPress Trac]

#2604: SQL Query Optimization
----------------------------+-----------------------------------------------
       Id:  2604            |      Status:  new                     
Component:  Administration  |    Modified:  Sat Apr  1 00:38:34 2006
 Severity:  normal          |   Milestone:  2.1                     
 Priority:  normal          |     Version:  2.0.2                   
    Owner:  ryan            |    Reporter:  ryan                    
----------------------------+-----------------------------------------------
Comment (by ryan):

 Added composite key (post_type, post_status, post_date) and shortened
 post_type from 100 to 20.  Didn't make a difference to performance.

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