WP-Optimize is an effective tool for automatically cleaning your WordPress database so that it runs at maximum efficiency.
Make space: When you edit a post or page on your website, WordPress automatically saves the new revision to the database. If you edit things a few times (and particularly if the post is long), your database soon gets clogged up with old revisions that just sit there, taking up valuable space. WP-Optimize removes these unnecessary post revisions, freeing up valuable Megabytes of data and increasing speed and efficiency. It also cleans up your comments table, removing all the spam and un-approved comments that have built up with a single click.
Take control: WP-Optimize reports on exactly which of your database tables have overhead and wasted space, giving you the insight, control and power to keep your website neat, fast and efficient.
Keep it clean: Once enabled, WP-Optimize can run an automatic clean-up on a schedule, keeping a selected number of weeks’ data, according to your specification.
When you use this plugin for the first time or just updated to major version, make a backup of your database (we recommend UpdraftPlus ). Though none of the queries used are dangerous, it is always the best practice to make a database backup before altering your database.