[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
-------------------------+--------------------------
Changes (by pento):

 * keywords:  has-patch commit => has-patch


Comment:

 On reflection, attachment:21435.diff isn't exactly the right solution. An
 index on `(comment_author,comment_author_email)` would be better, but it
 could get pretty big, and would be slow to create on big `wp_comment`
 tables.

 Maybe a 50 character prefix index would be a good trade off between size
 and query performance, but doesn't solve the problem of creating the
 index.

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