[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 nigro.simone):

 On MariaDB 10.1.9

 {{{
 SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
 (262 total, Query took 0.0156 seconds.)
 }}}

 ----

 {{{
 CREATE INDEX autoload ON wp_options(autoload, option_name);
 SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
 (262 total, Query took 0.0000 seconds.)
 }}}

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