[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:  Performance  |     Version:  trunk
 Severity:  normal       |  Resolution:
 Keywords:  has-patch    |
-------------------------+------------------------------

Comment (by nacin):

 Replying to [comment:4 DanBUK]:
 > And assuming that all wp_options tables will have > 30% autoload == yes
 isn't prudent, there are many ways in which people use the wp_options
 table.

 I disagree; it's a very fair assumption. "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. The alternative is each get_option() is an
 extra query, which you'd probably notice as a host.

 The maintenance of an index is not placing a lot of burden, no. But if the
 index is just sitting there waiting to be ignored, then it doesn't do us
 much good. The larger issue is that I haven't seen any evidence — in terms
 of performance or otherwise — to actually show that an index here would
 reduce the work to deliver the page.

 I'm not saying you've added an index to thousands of sites yet assuredly
 have no performance improvements to show for it. I'm saying, show us the
 measurable improvement so we can see it for ourselves.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/24044#comment:5>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software