[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):

 One thing to beware of with that would be the low cardinatlity on user_id
 on sites with few / a single author.  You could end up imposing drag on a
 query that pulls a lot of columns based on that.

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