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

 Going back to a point that was mentioned a while back, transients likely
 account for the vast majority of options that are not autoloaded, so
 perhaps the solution should be applied only when a site has enough of them
 to make a difference.

 Personally, I've seen loads of them created by WooCommerce, and some by
 Yoast SEO. Perhaps this is not a core issue, but one that should be
 addressed according to the plugins' use of transients. Problem is I can't
 think of a way to enforce this as a core edict, only as an appeal to the
 respective plugin developers.

 Maybe there can be an upgrade or periodic task to look at the ratio of
 autoloaded options to the total rows and if it exceeds, say, 0.5, the
 table can be altered. Alternatively, the number of transients can be
 counted and if greater than, say, 500, the table can be altered.

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