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

Comment (by cliffseal):

 So, the utility of this index is (roughly) inversely proportional to the
 percentage of rows where autoload = 'yes'? That'd make sense, considering,
 in my case, 0.001% of rows are such.

 To me, this now goes back to:

 Replying to [comment:5 nacin]:
 > "Ugly" plugins that add thousands of rows to a table are still very,
 very likely to autoload all of them, because that's the default.

 If that's the case, is there any way we can 'police' this behavior better
 with plugins, or define and encourage a best practice for it?

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