[wp-trac] [WordPress Trac] #21435: wp-includes/comment.php line85 causes slow query due to the non-indexed column

[WordPress Trac]

#21435: wp-includes/comment.php line85 causes slow query due to the non-indexed
column
------------------------------+-----------------------
 Reporter:  matsubobo         |       Owner:  pento
     Type:  enhancement       |      Status:  assigned
 Priority:  normal            |   Milestone:  3.9
Component:  Database          |     Version:  3.4.1
 Severity:  minor             |  Resolution:
 Keywords:  has-patch commit  |
------------------------------+-----------------------
Changes (by pento):

 * keywords:  has-patch => has-patch commit
 * milestone:  Future Release => 3.9


Comment:

 I like this index. I'd also expect it to speed up large import processes,
 which make liberal use of `comment_exists()`.

 attachment:21435.diff​ updates the patch to apply cleanly against trunk,
 and fixes a couple of typos in the original.

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