[wp-trac] [WordPress Trac] #24044: Add index to wp_options to aid/improve performance

WordPress Trac noreply at wordpress.org
Fri Apr 7 14:33:36 UTC 2017

#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
 - 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

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

More information about the wp-trac mailing list