How to Reduce WordPress Database Size to Speed Up your Blog

In WordPress by Fathi Arfaoui1 Comment

To get the maximum speed for your blog, you need to reduce 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 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. At the end, you will notice a better user experience and Google crawlers will access your content faster than before.

Read also: Importing WordPress database in PhpMyAdmin.

Delete post revisions and optimize your database

As I said reducing WordPress database size is one of the best ways to speed up your blog. WordPress by default saves and create post revisions, and if you have more than hundred of posts, you will notice a slower pages 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 you delete 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.

Reduce WordPress Database Size

You can also enable the auto cleanup 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 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, a 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.

Fathi Arfaoui: A Physicist, Blogger, and the founder and owner of Trustiko.com. He shares Business, Blogging, WordPress, Web Safety, and Blogging tips to build better websites and blogs. Also, he shares online marketing strategies and recommendations.

Comments

  1. I am using WP Optimize, and so far it works great. Thanks for the information anyways.

Leave a Comment