[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:  pento
     Type:  defect (bug)  |      Status:  assigned
 Priority:  normal        |   Milestone:  4.4
Component:  Database      |     Version:  2.0
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |     Focuses:  performance
--------------------------+--------------------------
Changes (by DrewAPicture):

 * keywords:  dev-feedback needs-refresh => dev-feedback
 * owner:   => pento
 * status:  new => assigned
 * milestone:  Future Release => 4.4


Comment:

 [attachment:26858.2.diff] refreshes the patch (hopefully I did that
 right). Also fixes a typo from the original patch:

 This:

 {{{
 KEY comment_post_ID_content (comment_post_ID, comment_content(255))
 }}}

 Should've been:

 {{{
 KEY comment_post_ID (comment_post_ID,comment_content(255))
 }}}

 Also, following [31349] I opted to use `$max_index_length` instead of 255.

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