[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:  (none)
     Type:  defect (bug)        |      Status:  reopened
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:
 Severity:  normal              |  Resolution:
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+------------------------------

Comment (by tofandel):

 Could we get motion on this seriously? It's such an easy fix that doesn't
 break BC

 This does improve performances a lot, without indexes my admin dashboard
 usually takes 4s to load, with this indexes it takes 2s

 With query debug enabled you can see a lot of slow options queries before
 taking 0.08s, and then they all disappear when the index is added

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