[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
--------------------------------+--------------------------
Changes (by pento):

 * keywords:  has-patch close => has-patch
 * status:  new => closed
 * resolution:   => maybelater
 * milestone:  Awaiting Review =>


Comment:

 Agreed, I'm open to revisiting this when we have more InnoDB users. As
 InnoDB use is steadily increasing, we'll get there eventually. :-)

 In the mean time, for folks who happen upon this ticket, you have two
 options:

 * Try adding this index yourself, and see if it improves performance for
 you
 * Use an [https://wordpress.org/plugins/tags/object-cache external object
 cache] to avoid hitting the DB

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