{"id":19679,"date":"2011-06-23T23:12:50","date_gmt":"2011-06-23T17:42:50","guid":{"rendered":"https:\/\/www.quickonlinetips.com\/archives\/?p=19679"},"modified":"2020-05-22T16:45:54","modified_gmt":"2020-05-22T11:15:54","slug":"optimize-wordpress-database","status":"publish","type":"post","link":"https:\/\/www.quickonlinetips.com\/archives\/2011\/06\/optimize-wordpress-database\/","title":{"rendered":"How to Optimize WordPress Database Easily"},"content":{"rendered":"<p>What is the best and easiest way to<strong> optimize WordPress database<\/strong>? It is a good idea to optimize your WordPress database tables as useless data &#8220;Overhead&#8221; piles up over the years and slows your database down.<\/p>\n<p>Our WordPress admin was getting really slow and so were the increasing \u00a0number of resource alerts. Like most WordPress bloggers, we too were always hesitant to meddle with the database fearing irreversible loss of data. There are many powerful WordPress database plugins, but they all seem too powerful and capable of modifying so much data, that it seemed better in expert hands. So we were looking for something very simple, easy and trustworthy.<\/p>\n<h3>Optimize WordPress Database<\/h3>\n<p>The we found the amazing <a href=\"https:\/\/wordpress.org\/plugins\/optimize-db\/\" rel=\"noopener\">Optimize DB plugin<\/a> by Yoast, who is a well known creator of some <a href=\"http:\/\/yoast.com\/wordpress\/\" rel=\"noopener\">other amazing plugins<\/a> too. We simply installed and activated the plugin and it automatically analyzed how much database overheads it could save instantly. Then we backed up the database, though <a href=\"https:\/\/www.quickonlinetips.com\/archives\/2011\/03\/vaultpress-secure-wordpress-backup-review\/\">Vaultpress<\/a> saves our latest database files automatically.<\/p>\n<p>This what a partial screenshot of what we got. The plugin was going to optimize our WordPress database and save it by 33%!<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-19703\" title=\"optimize-database\" src=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/optimize-database.png\" border=\"1\" alt=\"optimize database\" width=\"500\" height=\"202\" srcset=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/optimize-database.png 500w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/optimize-database-150x60.png 150w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/optimize-database-300x121.png 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/p>\n<p>Well there is only one button to click, and we clicked it. And in the next few seconds, it was all done.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-19704\" title=\"optimize-tables\" src=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/optimize-tables.png\" border=\"1\" alt=\"WordPress Database tables optimized\" width=\"311\" height=\"326\" srcset=\"https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/optimize-tables.png 311w, https:\/\/www.quickonlinetips.com\/archives\/wp-content\/uploads\/optimize-tables-286x300.png 286w\" sizes=\"(max-width: 311px) 100vw, 311px\" \/><\/p>\n<p>The WordPress admin speed seems better, site resource alerts seem lower too.<\/p>\n<p><strong><span style=\"color: #ff0000;\">Warning<\/span>:<\/strong> Always back up your full database before attempting any database changes. This seems standard disclaimer, but is very essential to restore your database if something goes wrong (and sometimes things do go wrong).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is the best and easiest way to optimize WordPress database? It is a good idea to optimize your WordPress&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[6],"tags":[49,17],"class_list":["post-19679","post","type-post","status-publish","format-standard","hentry","category-blogging","tag-tutorials","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/19679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/comments?post=19679"}],"version-history":[{"count":0,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/19679\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media?parent=19679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/categories?post=19679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/tags?post=19679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}