[wp-trac] [WordPress Trac] #21435: wp-includes/comment.php line85 causes slow query due to the non-indexed column
WordPress Trac
noreply at wordpress.org
Thu Feb 27 11:08:50 UTC 2014
#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
More information about the wp-trac
mailing list