[wp-trac] [WordPress Trac] #14711: Indexes for comment_author_email and user_id

[WordPress Trac]

#14711: Indexes for comment_author_email and user_id
--------------------------+-------------------------------------------------
 Reporter:  tellyworth    |       Owner:     
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  3.1
Component:  Comments      |     Version:  3.0
 Severity:  normal        |    Keywords:     
--------------------------+-------------------------------------------------

Comment(by mrmist):

 Replying to [comment:4 tellyworth]:
 >
 > There are already indexes on several columns that are or could be low
 cardinality (comment_approved, comment_parent, comment_post_ID). Will
 adding user_id make a significant difference?

 Probably not, but then simply because we are already doing something isn't
 necessarily a good reason to do something else.

 Note - I'm not dismissing the idea completely, just suggesting that impact
 of any new indexes should be tested across the various scenerios.

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