[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
--------------------------------+--------------------------

Comment (by fightthecurrent):

 Replying to [comment:1 nacin]:
 > Could you show some statistics for how this helps performance on your
 sites? See ticket:14258#comment:3 for why we have not done this.

 Here are some real world stats. Here you can see when the index was added
 to the options table:
 [[Image(http://i.imgur.com/gDt8eaR.png)]]

 Here you can see average transaction times decrease when the index was
 added:
 [[Image(http://i.imgur.com/dFGBbPW.png)]]

 And here you can see the load on the database decrease dramatically when
 the index was added:
 [[Image(http://i.imgur.com/EGhDD1R.png)]]

 I think adding the index is ''highly'' valuable. This comes from a site
 running WooCommerce where a large percentage of the records in the options
 table are transients, so there's no reason for them all to be loaded on
 every page load.

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