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

 Is this ever likely to happen?
 It seems it was actually requested here 6 years ago and closed as won't
 fix:
 https://core.trac.wordpress.org/ticket/14258

 There are two issues here:
 * There is a missing index (probably resulting in a table scan each time)
 * An unsuitable data type has been used of VARCHAR(20) (CHAR(1) would be
 much better with Y/N or better still BIT with 0/1)

 The two issues compound each other and I feel these are fairly basic
 relational database design principles.
 The first would require no product changes and would be low risk to
 implement
 The second would require some development work (table could be altered to
 VARCHAR(3) for a smaller improvement)

 Still after 6 years of asking, nothing has yet been done.
 Robin

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