{"id":11117323,"date":"2019-01-22T14:32:52","date_gmt":"2019-01-22T14:32:52","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/scalability-issues\/"},"modified":"2019-01-22T14:33:50","modified_gmt":"2019-01-22T14:33:50","slug":"scalability-issues","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/scalability-issues\/","title":{"rendered":"Scalability issues"},"content":{"rendered":"<p>On a site with 10,000+ posts and new ones being posted daily. How can we stop<br \/>\n<code>DELETE FROM wp_postmeta WHERE meta_key LIKE &#039;_rpbt_related_posts%&#039;;<\/code><br \/>\nfrom running so many times? I understand relevant related posts are important but if it clears the cache all the time MySQL is going to cripple the entire website.<\/p>\n<p>We need control over when this runs. ideally once a week would be acceptable.<\/p>\n","protected":false},"template":"","class_list":["post-11117323","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11117323","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":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11117323\/revisions"}],"predecessor-version":[{"id":11117328,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11117323\/revisions\/11117328"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=11117323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}