[wp-trac] [WordPress Trac] #9642: Database Schema Optimizations

[WordPress Trac]

#9642: Database Schema Optimizations
-------------------------------+--------------------------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:  Denis-de-Bernardy
     Type:  enhancement        |      Status:  accepted         
 Priority:  normal             |   Milestone:  2.9              
Component:  Optimization       |     Version:  2.8              
 Severity:  normal             |    Keywords:                   
-------------------------------+--------------------------------------------

Comment(by dbuser123):

 Replying to [comment:25 dd32]:
 > Probably because its not a query WordPress makes.
 I see, sorry for the disturbance.

 A minor improvement for the comments table: the first index is redundant
 since it is a prefix of the second one.
 KEY comment_approved (comment_approved),
 KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),

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