[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:  new
 Priority:  normal                       |   Milestone:  Awaiting Review
Component:  Options and Meta             |     Version:  3.6
 Severity:  normal                       |  Resolution:
 Keywords:  has-patch reporter-feedback  |     Focuses:  performance
-----------------------------------------+------------------------------

Comment (by nacin):

 I figured it would be transients.

 You should enable an external object cache, that way transients aren't
 stored in the database. If the lack of an index on this table forces
 hosting companies to consider the availability of an external object cache
 for their users, I'm not necessarily going to be bothered by that.

 I find it hard to justify an index that benefits an infinitesimal number
 of sites, probably slows down many others, especially were the sites
 affected have better steps to take to improve performance.

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