Speed Up Your WordPress Website by Cleaning Its Database

Posted by & filed under .

Slow page load speeds can be disastrous for an online business. Site speed is not merely imperative for a good user experience but is also one of the key factors utilized by search engines to determine page ranking. In other words, if your site is slow your Google search engine ranking might drop, which in turn will lead to a decrease in traffic. If you would like your site to be successful then you have to concentrate on its performance.

As far as user-friendliness is concerned, WordPress is definitely the most impressive platform out there. It gives you control over every aspect of your WordPress installation. You can add new features with the help of plug-ins or by modifying the source code of the software itself. However, because it is so feature-rich it can sometimes become slow. In this article you will learn how to speed up your wordpress website by cleaning its database.

What to delete?

There are a number of things that you can delete in order to make your database leaner. For instance you could get rid of:

Post revisions – Whenever you hit the ‘Save Draft’ button in WordPress, a new version of the post is added to the database. You can later compare these versions and revert to the one that you like best. While this is a great feature, it is completely useless for most bloggers. If you don’t find post revisions particularly useful, you should delete them from the wp_posts table of your database.

Orphan post meta entries – Plugin and theme developers use the wp_postmeta table to store extra information regarding posts. Sometimes when a post is deleted directly with a SQL query, its meta entries stay in the database. Deleting these entries can have a significant impact on website speed.

Trashed posts and comments – Instead of letting useless posts stay in the trash section, you should delete them completely. Same goes for comments.

Spam Comments – You should also empty out the spam section regularly to keep your database fast. In addition to each comment itself, WordPress stores several rows of associated information in the wp_commentsmeta table. In other words a single spam comment can end up creating dozens of rows in your tables.

How to delete?

There are a number of ways to delete the aforementioned items from your database. We have discussed the top two in the following paragraphs:

1. Plug-ins – Using plugins is the best way to keep your database tables optimized. Two popular extensions you can use are a) WP-Optimize and b) Database Browser. The former has been designed for quick optimization and can be used by novice users as well as programmers. The latter, however, requires familiarity with SQL syntax and is ideal for advanced users.

2. Cleaning up in PHPMyAdmin – PhpMyAdmin is an online database management system that you can use to create tables, run queries, conduct clean up activities, add new databases and back up existing ones. Plus there are several basic optimizations that can be done in phpMyAdmin. Just log into your cPanel account, click the PhpMyAdmin icon and delete the items that are not absolutely necessary for your website.

Database cleanup is one of the most underrated optimization techniques but it is very effective. Follow the tips given here to make your website faster.

Leave a Reply

Your email address will not be published. Required fields are marked *