[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:  closed
 Priority:  normal              |   Milestone:
Component:  Options, Meta APIs  |     Version:  3.6
 Severity:  normal              |  Resolution:  maybelater
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+--------------------------

Comment (by fightthecurrent):

 Replying to [comment:11 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.

 How about reducing 553,749 to 711?

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