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

 So I run a multisite install and our based _options table has 596386 rows
 in it
 - 298024 rows with a keyname that starts with "_transient_timeout_jpp"
 (JetPack related)
 - 298108 rows that start with "_transient_" but not
 "_transient_timeout_jpp"
 - 254 rows that do not start with "_transient_".

 Due to this we had severe performance issues with the autoload query from
 this table.  Adding the index on autoload immediately improved
 performance.  Adding the index by default seems to be such a small thing
 to do by default for the cases where people exceed the norm (which will be
 the majority of small websites).

 Hopefully this ticket can be implemented so others don't have the same
 problem.

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