[wp-trac] [WordPress Trac] #26858: Comment duplicate check has a slow query

[WordPress Trac]

#26858: Comment duplicate check has a slow query
------------------------------------+------------------
 Reporter:  pento                   |       Owner:
     Type:  defect (bug)            |      Status:  new
 Priority:  normal                  |   Milestone:  3.9
Component:  Database                |     Version:  2.0
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |
------------------------------------+------------------

Comment (by pento):

 That's a good point, adding a one-off index isn't a great solution.

 A problem could be if an admin has unchecked the "Comment author must fill
 out name and e-mail" option, that would possibly result in many comments
 having empty name/email fields. I don't expect that to be a common
 problem, though.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/26858#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform