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

 @jorbin, thanks for the reply.
 I'm just wondering but could an upgrade script not possibly move WordPress
 (or at least that table) to InnoDB maybe with a prompt during the upgrade
 stating the benefits of InnoDB as otherwise people may just carry on using
 MyISAM without realising there is a choice and the issue will never be
 able to be solved with possible further fragmentation in future.

 I helped a client solve an issue where they were using MyISM and Dutch as
 the codepage because the previous hosting provider had these set as
 default (the website was not Dutch).

 Also the Ticket URLs in emails never work either and display this error:

 {{{
 No handler matched request to /ticket/24044#comment:58
 }}}

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