[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:  pento
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  4.8
Component:  Database      |     Version:  2.8.1
 Severity:  normal        |  Resolution:  fixed
 Keywords:  has-patch     |     Focuses:  performance
--------------------------+--------------------------

Comment (by mnelson4):

 > We could try to calculate the number of affected rows inside of
 dbDelta() and set a reasonable default threshold where these kinds of
 alter's are allowed to run automatically.

 +1.

 Or network admins could decide (there could be a constant which could
 control whether we want to automatically modify DB key lengths). They will
 probably know best if they want automatic key length modifications (and if
 they aren't going to do it automatically, they need to figure out some
 other system to do it manually).

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