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

 What's the purpose behind adding option_value to that index? It looks like
 it would only serve to increase the length of the index.

 What's the performance difference on these queries? Reducing rows examined
 from 1460 to 178 (or even 10,000 to 100) is still peanuts. DanBUK
 mentioned adding this index many times daily, but I am trying to figure
 out if that was simply cathartic or if it was actually making a
 difference.

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