[wp-trac] [WordPress Trac] #34870: dbDelta Not Specifying Key Length Duplicate Indexes

[WordPress Trac]

#34870: dbDelta Not Specifying Key Length Duplicate Indexes
--------------------------+------------------------------
 Reporter:  charlestonsw  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  2.8.1
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+------------------------------

Comment (by charlestonsw):

 That said, we should check for BOTH cases and do what we can to either
 eliminate duplicate indexes with logic or make sure the documentation,
 both the old Codex page and the new code reference, are far more explicit.

 Duplicate indexes is a common problem with plugins that create their own
 tables.   It is a notable performance drain as the index count increases.
 Especially on older PHP & MySQL versions.

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