[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 robinwilson16):

 I am just looking into performance issues on someone's WordPress site and
 why after 3 years has nothing been done?
 There is no logic to making autoload of type VARCHAR(20) as it wastes
 space and is inefficient as shown above and an index would drastically
 improve performance for all the many installs out there.

 I would have thought a type of CHAR(1) would be best with Y and N but
 obviously this would take development time whereas adding the index would
 not.

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