[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
Sat Mar 8 22:31:58 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:  Future Release
Component:  Database     |     Version:  3.4.1
 Severity:  minor        |  Resolution:
 Keywords:  has-patch    |     Focuses:  performance
-------------------------+-----------------------------
Changes (by nacin):

 * milestone:  3.9 => Future Release


Comment:

 I'd like to fix this. However, it is too late in the 3.9 cycle for a
 schema change.

 I'm curious about a few things. Namely:
  * Which index is generally going to be the best balance of speed and
 size, for what we do now and what we may do in the future? There are some
 good discussions here and possibly even a consensus, but yet a lot of data
 to back up a decision.
  * Why haven't others reported this? 600,000 records in wp_comments isn't
 that unusual. Surely WordPress.com would have noticed this by now? Do
 giant sites just actively or incidentally avoid the comment_whitelist
 option? ("Comment author must have a previously approved comment")

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


More information about the wp-trac mailing list