[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:  Awaiting Review
Component:  Comments      |     Version:  3.0            
 Severity:  normal        |    Keywords:                 
--------------------------+-------------------------------------------------
 There are currently no indexes on any of the author columns in
 wp_comments.  That means there's no efficient way to count the comments
 written by a given commenter, for example.

 The enclosed patch adds two separate non-unique indexes, one each for
 comment_author_email and user_id.

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