[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:  (none)
     Type:  defect (bug)        |      Status:  reopened
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:
 Severity:  normal              |  Resolution:
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+------------------------------

Comment (by robinwilson16):

 This is always a problem on larger WordPress sites and I can't understand
 why after 9 years no one has added this index (there is an older ticket
 for this recorded as won't fix: #14258).

 Also there is no logic to making the autoload column VARCHAR(20) as it
 wastes space and is inefficient. It should be either BIT/CHAR(1). However
 this would take dev time though whereas a simple index would not.

 What is the reason for not implementing this change? It is a minor change
 with a major positive impact.

 In the 9 years that have passed since this was first flagged has anyone
 ever experienced a negative impact to this change?
 In that time a lot has moved to the cloud and we are charged by each CPU
 cycle so as well as being slower it also costs more.

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