Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #24044, comment 62


Ignore:
Timestamp:
08/24/2016 02:06:25 PM (8 years ago)
Author:
jkhongusc
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #24044, comment 62

    initial v1  
    1111
    1212We are planning to add a caching layer, either Redis or memcached, which will increase our use of transients.  Will we run into a problem even with the autoload index when we have thousands of options autoloaded? I need to find an answer to my two questions above.
     13
     14Running the query below on our test system without an index, runs really fast even though it is doing a full table scan (.01 seconds); but the row count on wp_options is 3k.  This is why I suspect the lack of index alone is not an issue at least for our case.
     15select option_name, option_value from wp_options where autoload = 'yes';