[wp-trac] Re: [WordPress Trac] #3170: Sites installed with 2.0 and newer do not have the post_status index. This slows WP sites.

[WordPress Trac]

#3170: Sites installed with 2.0 and newer do not have the post_status index. This
slows WP sites.
----------------------------+-----------------------------------------------
 Reporter:  BrianLayman     |        Owner:  anonymous
     Type:  defect          |       Status:  new      
 Priority:  high            |    Milestone:  2.0.5    
Component:  General         |      Version:  2.0      
 Severity:  normal          |   Resolution:           
 Keywords:  Database index  |  
----------------------------+-----------------------------------------------
Comment (by intoxination):

 +1 for this. I have gone through and manually added the post_status index
 on a couple of sites with 10,000+ posts and it made a very noticeable
 performance increase.

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