This will show you how to optimize WordPress database quickly and easily.
This is really an important speed optimization tool for your WordPress site. And the best part is we can set it to run automatically so we don’t have to think about doing this ever again!
But first some background, as some of you may be asking:
“What is the WordPress database?”
The database is a server-side file that is updated dynamically by the PHP software (WordPress) to store all relevant information about your site including all the content and settings of you website. It’s part of what makes the WordPress system so awesome.
The only problem is that things slow down when the database gets full of information that is no longer critical. The server has to search through a lot of unnecessary data to get to what it’s looking for.
Fortunately there is a plugin we can install to make this really easy.
How to optimize WordPress database
1. Download and install a plugin called WP-Optimize.
2. Visit the new option in the sidebar, WP-Optimize and optimize your database tables by clicking the Process button.
NOTE: The default settings will delete all post revisions and auto-drafts (saved drafts when writing a post). You can un-tick these boxes if you want to be able to use those options.
3. Click the Settings tab to setup the automatic optimization schedule.
Again make sure that you’re OK with cleaning out your auto-drafts and post revisions each week. If not just untick this box before saving.
Now your blog will optimize the WordPress database every week. Part of your speed optimization strategy is now running on auto pilot.
Let me know if you have any questions or issues in the comments.