[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 galbaras):

 It should be easy enough to write code that checks for the storage engine
 and does the best for what it finds.

 It should be equally as easy to decide that InnoDB is the way to go for
 wp_options on MySQL (5.5+), given the the update frequency and
 granularity, an simply ensure that that's the case, possibly during
 install and core updates.

 In fact, the code can even run some test queries with and without the
 index, and leave the better one.

 It's a wonderful world of WordPress out there :)

 Personally, I've switched to InnoDB and create the autoload index on
 wp_options and my sites smile at me as they zoom by.

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