{"id":7289458,"date":"2016-04-18T09:26:18","date_gmt":"2016-04-18T09:26:18","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/slow-query-when-opening-dashboard\/"},"modified":"2016-08-31T16:01:27","modified_gmt":"2016-08-31T16:01:27","slug":"slow-query-when-opening-dashboard","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/slow-query-when-opening-dashboard\/","title":{"rendered":"slow query when opening dashboard"},"content":{"rendered":"

Almost 14 second wait in development environment.<\/p>\n

Mysql Explain<\/a>
\nOutput from Query Monitor<\/a><\/p>\n

~ 150’000 rows total in wp_posts table.<\/p>\n

https:\/\/wordpress.org\/plugins\/wordpress-seo\/<\/p>\n","protected":false},"template":"","class_list":["post-7289458","topic","type-topic","status-publish","hentry","topic-tag-query"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7289458","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\/7289458\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=7289458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}