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

Comment (by robinwilson16):

 Totally agree! Thanks @DanBUK at least we got there in the end!

 At a college we used a large popular college MI system that had zero
 clustered indexes on any tables. It took a lot of evidence and
 perseverance to convince the software suppliers they needed these with
 them just saying their software was "special" and there was no benefit! I
 had to provide sustained evidence of the massive improvements (processes
 went from running all night to taking about a minute) and then one day
 they suddenly agreed with me and used my scripts to apply the change to
 all customers across the UK. It's difficult to fix performance issues when
 it is poor dev practices and not the servers, plus amending databases can
 invalidate support agreements.

 Replying to [comment:85 apedog]:
 > @DanBUK should get honorable mention in the next release. For real.
 >
 > Its funny reading these threads from 5-8 years ago. The original posts
 make perfect sense, and the push-back just seems so arbitrary. And then -
 no more push-back. (Tho this is really very similar to the push-back I
 read in make.core regarding things like major version auto-updates. The
 push-back from leads is real, almost un-open-source-like in its essence.
 But the reasoning behind it just doesn't stand the test of time).

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