{"id":59,"date":"2021-08-14T10:47:24","date_gmt":"2021-08-14T10:47:24","guid":{"rendered":"https:\/\/docs.poweredcache.com\/?p=59"},"modified":"2021-08-14T10:47:26","modified_gmt":"2021-08-14T10:47:26","slug":"database-optimization","status":"publish","type":"post","link":"https:\/\/docs.poweredcache.com\/database-optimization\/","title":{"rendered":"Database Optimization"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Database Optimization clears out all of this unnecessary data, cleans up your tables.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"980\" height=\"619\" src=\"https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/db-optimizations.png?rs=fill&#038;w=980&#038;h=619&#038;ssl=1&#038;format=webp\" alt=\"\" class=\"wp-image-60\" srcset=\"https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/db-optimizations.png?w=1271&amp;ssl=1&amp;format=webp 1271w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/db-optimizations.png?rs=fill&amp;w=300&amp;h=190&amp;ssl=1&amp;format=webp 300w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/db-optimizations.png?rs=fill&amp;w=1024&amp;h=647&amp;ssl=1&amp;format=webp 1024w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/db-optimizations.png?rs=fill&amp;w=768&amp;h=485&amp;ssl=1&amp;format=webp 768w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/db-optimizations.png?rs=fill&amp;w=60&amp;h=38&amp;ssl=1&amp;format=webp 60w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/db-optimizations.png?rs=fill&amp;w=150&amp;h=95&amp;ssl=1&amp;format=webp 150w\" sizes=\"(max-width: 980px) 100vw, 980px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How does it work?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Database Optimization triggers when hit on the &#8220;Save Settings and Optimize&#8221; button under the Database Settings. The optimization items will be added to the queue and batches will be processed as smaller chunks. PoweredCache uses WordPress internal functions to remove data particularly to provide maximum compatibility with other plugins.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Schedule Cleanups<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">PoweredCache can clean up DB based on the schedule, with this feature you don&#8217;t need to manually click on the optimize button every time. It&#8217;s one of the best ways to keep redundant data out of the database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"980\" height=\"290\" src=\"https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups-1024x303.png?rs=fill&#038;w=980&#038;h=290&#038;ssl=1&#038;format=webp\" alt=\"\" class=\"wp-image-61\" srcset=\"https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups.png?rs=fill&amp;w=1024&amp;h=303&amp;ssl=1&amp;format=webp 1024w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups.png?rs=fill&amp;w=300&amp;h=89&amp;ssl=1&amp;format=webp 300w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups.png?rs=fill&amp;w=768&amp;h=228&amp;ssl=1&amp;format=webp 768w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups.png?rs=fill&amp;w=1536&amp;h=455&amp;ssl=1&amp;format=webp 1536w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups.png?rs=fill&amp;w=60&amp;h=18&amp;ssl=1&amp;format=webp 60w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups.png?rs=fill&amp;w=150&amp;h=44&amp;ssl=1&amp;format=webp 150w, https:\/\/img.poweredcache.net\/docs.poweredcache.com\/wp-content\/uploads\/2021\/08\/scheduled-cleanups.png?w=1964&amp;ssl=1&amp;format=webp 1964w\" sizes=\"(max-width: 980px) 100vw, 980px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p class=\"has-luminous-vivid-amber-background-color has-background wp-block-paragraph\">Scheduled cleanup is only available with the premium version.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Optimization clears out all of this unnecessary data, cleans up your tables. How does it work? Database Optimization triggers when hit on the &#8220;Save Settings and Optimize&#8221; button under the Database Settings. The optimization items will be added to the queue and batches will be processed as smaller chunks. PoweredCache uses WordPress internal functions [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"powered_cache_disable_cache":false,"powered_cache_disable_lazyload":false,"powered_cache_disable_ucss":false,"powered_cache_specific_ucss":false,"footnotes":""},"categories":[35],"tags":[38,36,37],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-database","tag-cleanup","tag-database","tag-database-optimize"],"_links":{"self":[{"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":1,"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"predecessor-version":[{"id":62,"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/posts\/59\/revisions\/62"}],"wp:attachment":[{"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.poweredcache.com\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}