[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:  reopened
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:
 Severity:  major               |  Resolution:
 Keywords:  has-patch           |     Focuses:  performance
--------------------------------+------------------------------

Comment (by jeichorn):

 @jkhongusc yeah so thats what i mentioned at the end of my notes.  Table
 scan queries even when fast are heavy cpu users on the database.  If you
 do your benchmarks at high concurrency you should see a larger effect from
 the index.

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