[wp-trac] [WordPress Trac] #24044: Add index to wp_options to aid/improve performance

[WordPress Trac]

#24044: Add index to wp_options to aid/improve performance
--------------------------------+------------------------------
 Reporter:  DanBUK              |       Owner:
     Type:  enhancement         |      Status:  new
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:  3.6
 Severity:  normal              |  Resolution:
 Keywords:  has-patch close     |     Focuses:  performance
--------------------------------+------------------------------
Changes (by jorbin):

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


Comment:

 I think we need to pull the trigger and make a decision here rather than
 letting this ticket waste away.

 All the testing shows that adding it reduces performance for MyISAM which
 if we take a "first, do no harm" approach, means that this comes accross
 as a non starter.  I think we should close as maybelater and if evidence
 of it not harming performance for MyISAM comes up, we can revisit.

 This of course doesn't prevent individual site owners from adding the
 index themselves.

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