[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:  reopened
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:
 Severity:  major               |  Resolution:
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+------------------------------

Comment (by ReneHermi):

 Lets create an conditional alter statement which adds an index only when
 innodb is used! We have the year 2016, innodb is used as the default db in
 all serious hosting companies today.

 Make a cut and do not stuck in the past. This small change will save
 energy, costs and natural resources worldwide. Save a tree, add an index
 to wp_options!

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