{"id":1443484,"date":"2010-03-29T07:49:55","date_gmt":"2010-03-29T07:49:55","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/optimize-wp_options-table\/"},"modified":"2016-08-19T16:27:51","modified_gmt":"2016-08-19T16:27:51","slug":"optimize-wp_options-table","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/optimize-wp_options-table\/","title":{"rendered":"Optimize wp_options table"},"content":{"rendered":"<p>Hi, <\/p>\n<p>I was looking through some MySQL logs on my server, checking for slow queries and non-indexed queries. There seem to be a lot of queries like this:<br \/>\nSELECT option_name, option_value FROM wp_options WHERE autoload = &#8216;yes&#8217;<\/p>\n<p>Autoload is not indexed, shouldn&#8217;t it be ?<\/p>\n<p>The column type is set to var, wouldn&#8217;t be more efficient to be enum(&#8216;yes&#8217;,&#8217;no&#8217;) ?<\/p>\n<p>Will Macdonald<\/p>\n","protected":false},"template":"","class_list":["post-1443484","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/1443484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/1443484\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=1443484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}