[wp-trac] [WordPress Trac] #42204: _options table missing an index on autoload column

[WordPress Trac]

#42204: _options table missing an index on autoload column
--------------------------+-----------------------------
 Reporter:  DionDesigns   |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  4.8.2
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 '''wp-includes/options.php''' has the following line:


 {{{
 if ( !$alloptions_db = $wpdb->get_results( "SELECT option_name,
 option_value FROM $wpdb->options WHERE autoload = 'yes'" ) )
 }}}

 However, the "autoload" column is not indexed. This can lead to
 significant performance degradation if the '''''_options''''' table is
 large.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/42204>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform