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

 Replying to [comment:1 westi]:
 > This sounds reasonable.
 >
 > Got any idea how long the table upgrade to add those might take on a
 site with alot of comments versus how much quicker they will make the
 queries?

 Not the foggiest.  I can see user_id being trivial.  comment_author_email
 has the potential to be large in some circumstances.  It might be worth
 limiting that index to 8 or 10 characters or thereabouts if that's a
 concern.

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