[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:  new
 Priority:  normal                       |   Milestone:  Awaiting Review
Component:  Options and Meta             |     Version:  3.6
 Severity:  normal                       |  Resolution:
 Keywords:  has-patch reporter-feedback  |     Focuses:  performance
-----------------------------------------+------------------------------

Comment (by cliffseal):

 Also, I went through these steps again and ran the SELECT query a few more
 times after removing the index as requested. Still got:

 {{{
 628 rows in set (2.24 sec)
 628 rows in set (2.24 sec)
 628 rows in set (2.23 sec)
 }}}

 Then:

 {{{
 CREATE INDEX autoload ON wp_options(autoload, option_name);
 SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
 628 rows in set (0.01 sec)
 628 rows in set (0.01 sec)
 628 rows in set (0.00 sec)
 }}}

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