Opened 13 years ago
Closed 13 years ago
#19935 closed defect (bug) (fixed)
Redundant index in comment table schema
Reported by: |
|
Owned by: |
|
---|---|---|---|
Milestone: | 3.4 | Priority: | normal |
Severity: | normal | Version: | 3.3.1 |
Component: | Database | Keywords: | early |
Focuses: | Cc: |
Description
From and lost and buried : http://core.trac.wordpress.org/ticket/9642#comment:26
A minor improvement for the comments table: the first index is redundant since it is a prefix of the second one. KEY comment_approved (comment_approved), KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
props dbuser123
We should do this in 3.4 seeing as we are already tweaking db schemas
Attachments (3)
Change History (4)
Note: See
TracTickets for help on using
tickets.
In [19799]: