[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:  reporter-feedback
--------------------------+-------------------------------------------------

Comment(by tellyworth):

 @hakre: we'd like to use this in the Akismet plugin, see
 http://plugins.trac.wordpress.org/ticket/1198 and the corresponding
 changeset http://plugins.trac.wordpress.org/changeset/294390

 That query will almost certainly change before the plugin release, but
 it'll give you an idea of what we're trying to do and demonstrate that
 there's a practical need.

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