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

Comment (by DanBUK):

 So if we go around in circles... As I have with my view of how it's been
 received.

 The original resistance to adding this index was due to MyISAM usage; even
 by WordPress.org. Which at any time is a bad idea. We are now at a time
 when InnoDB or other newer storage engines exist and are used by default.


 A. Every lookup of a page on a wordpress site checks the wp_options for
 how the plugins should operate.
 B. They depend upon autoload being true
 C. It's cardinality of index is very high, its either true or false.

 Just add the index...

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