Changes between Initial Version and Version 1 of Ticket #24044, comment 62
- Timestamp:
- 08/24/2016 02:06:25 PM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #24044, comment 62
initial v1 11 11 12 12 We 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 14 Running 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. 15 select option_name, option_value from wp_options where autoload = 'yes';