[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:  Performance             |     Version:  3.6
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |
------------------------------------+------------------------------

Comment (by cliffseal):

 I was just trying to replicate his results.

 I wish I had tracked the difference when I added it to a much larger
 version of that same app—important queries went from several seconds in
 some cases to < 1 in all. I assure you it was directly related to adding
 an autoload index.

 Again, I know this isn't the most common configuration, but it's allowing
 me to work with tons of transients at once with decent page load times.

 If you can tell me what sort of feedback/results you need, I'll find a way
 to get it for you.

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