[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 and Meta  |     Version:  3.6
 Severity:  normal            |  Resolution:
 Keywords:  has-patch         |     Focuses:  performance
------------------------------+------------------------------
Changes (by DanBUK):

 * keywords:  has-patch reporter-feedback => has-patch


Comment:

 I've performed some slightly different testing. With some restrictions.

 As we are only issuing queries with autoload=yes the results for =no are
 not relevant.

 With any site that has a high level of read/write concurrency MyISAM won't
 scale. (You would be surprised how many modules update wp_options on every
 page load.)

 The results indicate that only in the case when 50% or more of the rows
 have autoload=yes things slow down. But this is by a negligible amount,
 even with 100k rows in wp_options the difference was only 0.02s (6.45%).
 Yet in the case of 100k rows and 20% of the rows have autoload=yes the
 gains in speed are 0.07s (35%).

 Therefore I propose that the gains offered by adding this index outweigh
 the losses.

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