[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 reporter-feedback  |     Focuses:  performance
-----------------------------------------+------------------------------

Comment (by DanBUK):

 Replying to [comment:22 DanBUK]:
 > But that is the thing, we are moving into the realm of database
 optimisation, and to be honest from my view that isn't always seen by
 developers. Don't even get me started on Magento.

 My main basis for this is that developers don't see the application later
 in production on much busier sites that their test box that takes 10
 requests per minute. Once you are dealing with a site that takes 100
 requests per second minor changes to indexes in this suggestion make a
 huge difference. The Read/Write ratio is what counts.

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