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

Comment (by pento):

 I've had a bit more of a play around with my MySQL settings, but I haven't
 managed to make performance suck less on MyISAM.

 I'm using a standard [https://github.com/Varying-Vagrant-Vagrants/VVV VVV]
 install for testing. You're welcome to play around with it and see if you
 can get better performance out of it, but I'm strongly inclined to not add
 this index. VVV is a pretty popular base for WordPress dev shops to create
 sites with these days, so if I'm running into performance problems,
 there's a good chance a bunch of other sites will, too.

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