How to Reduce WordPress Database Size to Speed Up your Blog

To get the maximum speed for your blog, you need to reduce the WordPress database size. This one of the easiest solutions to optimize and clean up your website. This is a very important step that not only will speed up your site and make it faster but also, it will save your bandwidth and the server resources, especially for medium and large size blogs.

It’s not a secret that Google and the other search engines consider your website’s loading time, and that can affect your ranking in a small percentage. This never means that getting a speed website or blog will boost your ranking, but, it helps crawlers to access your web pages and give a better user experience also.

If your blog loads in more than 10 seconds, you should stop working now and optimize your blog. If you’re happy with your slow pages, then, visitors are not, it’s not a hard job to do in the majority of cases, sometimes you need just to install a plugin or make simple changes in your layout or any other way to work on it. In the end, you will notice a better user experience and Google crawlers will access your content faster than before.

Delete post revisions and optimize your database

As I said reducing the WordPress database size is one of the best ways to speed up your blog. WordPress by default saves and creates post revisions, and if you have more than hundreds of posts, you will notice a slower page loading caused by unnecessary database tables, so deleting these revisions is the solution you should make.

The best and safest way to do that is installing the great WordPress Optimize plugin, it’s your blog cleaner and optimizer from today. All you have to do is to activate it and check the options that you want to delete. Of course, this plugin will only show your data, and things that you don’t need and never risk your blog, so don’t worry about your posts and data.

WordPress Optimize suggests deleting things like, post revisions, auto draft posts, and spam comments that are not approved. If you’re one of those who get thousands of spam comments, then, you should delete them.

Related:  Video Recording for WordPress Visitors in Real Time

Reduce WordPress Database Size

You can also enable the auto clean up option in the plugin settings, it’s a scheduled cleaning that you can set for every week or twice a month, or what you want. Thus, you save time if you have lots of posts and spam comments to delete.

If for any reason, you don’t want to install this plugin, you can disable the post revision option in WordPress by adding the below code in your wp-config.php file.

define('WP_POST_REVISIONS', false );

Now you have optimized your blog through the MySQL database and you will notice a better loading time and speed. But, remember that the fast hosting provider still the most important thing to have, fast server can make your blog available all the time and give your visitors a happy experience.

People will come back and visit your site again, at the same time, it’s a great idea to have a CDN if you have resources of course. Thus, you will give your blog the maximum speed and performance and that will help in your search engine ranking.

Avatar for Fathi Arfaoui
About Fathi Arfaoui

Fathi Arfaoui is a Physicist, Blogger and the founder of Trustiko.com. He shares Business, WordPress and Blogging tips to build a better blog and succeed online.

Disclosure: The recommendations on this page are my own based on my tests and analysis. We may earn a small commission from web hosts and other partners if you use my referral link to make a purchase. That’s what helps us to maintain the site and add fresh content, Thanks for your support.

Leave a Comment