Changes between Initial Version and Version 1 of Ticket #24044, comment 34
- Timestamp:
- 07/01/2014 07:05:05 AM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #24044, comment 34
initial v1 2 2 3 3 Before index 4 {{{ 4 5 mysql> explain select option_name, option_value from wp_options where autoload = 'yes'; 5 6 +----+-------------+------------+------+---------------+------+---------+------+--------+-------------+ … … 8 9 | 1 | SIMPLE | wp_options | ALL | NULL | NULL | NULL | NULL | 807663 | Using where | 9 10 +----+-------------+------------+------+---------------+------+---------+------+--------+-------------+ 11 }}} 10 12 11 13 After index: 14 {{{ 12 15 mysql> explain select option_name, option_value from wp_options where autoload = 'yes'; 13 16 +----+-------------+------------+------+---------------+----------+---------+-------+------+-----------------------+ … … 16 19 | 1 | SIMPLE | wp_options | ref | autoload | autoload | 62 | const | 265 | Using index condition | 17 20 +----+-------------+------------+------+---------------+----------+---------+-------+------+-----------------------+ 21 }}} 18 22 19 23 We are talking about reducing query time by 1 second in this instance. As the average size of wp_options grows and grows its a nice low cost index to add that protects people from plugins that use wp_options as a temp data store.