[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:  assigned
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  2.0
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+-----------------------------
Changes (by pento):

 * keywords:  dev-feedback has-patch =>
 * owner:  pento =>
 * milestone:  4.4 => Future Release


Comment:

 Adding a single index isn't the right way to go - as @nacin mentioned,
 this needs a deeper dive into the queries used by the various comment
 functions, to see if we can make several of them better at once, rather
 than adding an index that's only used by one function.

 As a side note, `comment_post_ID_content` is the correct index name - it's
 a compound index, so it's named for both columns - like
 `comment_approved_date_gmt (comment_approved,comment_date_gmt)`.

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