[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:  pento
     Type:  defect (bug)        |      Status:  closed
 Priority:  normal              |   Milestone:  5.3
Component:  Options, Meta APIs  |     Version:
 Severity:  normal              |  Resolution:  fixed
 Keywords:  has-patch commit    |     Focuses:  performance
--------------------------------+--------------------------
Changes (by pento):

 * owner:  (none) => pento
 * status:  reopened => closed
 * resolution:   => fixed


Comment:

 In [changeset:"45805" 45805]:
 {{{
 #!CommitTicketReference repository="" revision="45805"
 Schema: Add an index to `wp_options.autoload`.

 Most sites will be unaffected by this change, but those with a large
 number of rows in `wp_options`, only a small number of which have
 `autoload` set, will see a significant performance improvement.

 Sites with a large number of rows in `wp_options`, with many of them
 having `autoload` set will unfortunately see a performance penalty on top
 of the already very slow queries they're running, but this should be the
 minority of cases.

 Props DanBUK.
 Fixes #24044.
 }}}

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