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

 I have a wp_options table with over 600,000 records, mostly WooCommerce
 sessions and transients, which used to load the initial "autoload" query
 in 2.5 seconds, just like yours. After creating a secondary index on
 "autoload", it's loading in 0.01 seconds and the site is MUCH faster in
 general, possibly because this query prevented table updates while it was
 being scanned without the index.

 To me, such a small index is not something that should be so strictly
 opposed, considering it affects a core query executed by every page. It's
 just likely to speed many sites up, including some sites whose owners
 don't know phpMyAdmin from a bar of soap.

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