[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    |     Focuses:  performance
-------------------------+--------------------------

Comment (by matsubobo):

 I'm currently managing 700,000 records in `wp_comments` table and works
 fine with this index setting.

 Please see the my table information on production.
 https://www.evernote.com/shard/s363/sh/09b52bd7-54c0-4ec1-b985-b9cf86cea3fb/6c6a5cc2aa051206c4e375a2ac0274ab

 I hope this patch will be applied as soon as possible because this index
 increase much performance for large scale wordpress site with less cpu and
 data cost.

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