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

[WordPress Trac]

#9642: Database Schema Optimizations
-------------------------------+-----------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:
     Type:  enhancement        |      Status:  assigned
 Priority:  normal             |   Milestone:  Future Release
Component:  Optimization       |     Version:  2.8
 Severity:  normal             |  Resolution:
 Keywords:  needs-patch        |
-------------------------------+-----------------------------

Comment (by westi):

 Replying to [comment:26 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),

 This is lost and buried in this very generic ticket so I've raised a new
 one #19935

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