WordPress.org

Ready to get started?Download WordPress

Plugin Reviews

Optimize Database after Deleting Revisions

Optimizes the WordPress Database after Cleaning it out

84 reviews
Average Rating
4.8 out of 5 stars
A super-huge support
By , for WP 4.1.1

The plugin is great and absolutely useful, but the support is unvaluable!

Fast, reliable and very professional! Thank you Rolf.

I love the Spam deletion part
By , for WP 4.1.1

This works well, and trimmed out many revisions, I set it to leave just 1 revision. It trimmed 41.5 MB on the first run, reducing down to 68.12 MB from 109 MB

But the fact that it can also automatically remove all comments marked as spam saves me another job each day. 5 stars for this.

great plugin!
By ,

Thanks for great plugin. Very useful

Great tool
By ,

Very helpful and easy to use. Thanks for this.

Better than Others for WooCommerce Product Orphans
By , for WP 4.1

If you use WooCommerce and import products with the same name as ones you previously deleted, either through CSV or manually, their names won't show up in the products. That's because they are still in the database as orphans with the status of being deleted. After trying to resolve this issue with three of the other top WP DB optimizers, this is the only one that actually got rid of those orphans, cleaning up my database to work freely with product names again.

The only thing I don't like about this plugin, besides its cumbersome name, is its layout in the Dashboard. Certainly the one-click DB optimize button at the top is fine, although the "(1-click)" part of its title can go. We're not stupid, we know it's a one-click button, because settings requires the tick to make it so. Also, do we need to see the author's name and website links every time we run the plugin? And in the settings, as well? Most plugin authors relegate that info to the plugins list.

All in all, it is the best DB optimizer I've tried. I think I'll stick with it. Hopefully, the author will, too. There are far too many plugins not keeping up with the WordPress versions throughout the years.

Excellent Plugin - Just Needs to be Multisite Effective
By , for WP 4.1

I struggled with selecting the rating. This plugin is absolutely worthy of 5-stars. But it not comprehensive in a multisite environment.

So I gave it 4-stars hoping to prompt some encouragement to extend the plugin to be a true multisite compatible.

Let me explain:

  • when Network Activated at the primary site, for example, all the database tables get optimized -- Excellent !
  • However, the Deleting Revisions functions only work against the Sites in the Activated Network and not against all sites in the Multisite Network system -- so it causes you to have to Network Activate the plugin in each network to get the Deleting Revisions functions to work. It would be ideal if there was a checkbox option to run the Deleting Revisions functions against all tables in the Multisite Network's Database and not just the active network
  • Here's a great feature of the current plugin -- when you delete comments, the plugin is smart enough to know to delete the comments' corresponding meta in the _commentsmeta table - awesome job !!

Also, here are some suggestions to make the plugin even more powerful:

  • After deleting the revisions, especially the spammed comments, it would be great if you reset the auto increment value in the table's key index
Great!
By , for WP 4.1

Optimize database and makes the slow db fast :-)

Wow!
By , for WP 4.1

I was using WP Optimizer but was actually benefitting from it because it does not support InnoDB - so basically, it was just deleting transient options.

I ran this on my DB and - even though I have been manually dropping tables, and cleaning the WP Options table, this plug-in was still able to remove 1.6mb of crud.

I love the scheduling feature, too.

Thank you!

L

P.S. Please consider re-naming the plug-in. I was a little scared to use it because of the name but the reviews said it rocked, and it did!

P.P.S. Please add the deletion of pingbacks and trackbacks in the next version.

Excellent Plugin
By , for WP 4.0

Easy to use and frees up wasted space in DB, also optimises too which is a great help saves going into phpMyAdmin

Really helpful
By , for WP 4.0

This plugin works well, really helpful to decrease required time for deleting revision. No more PHPMyAdmin!

You must log in to submit a review. You can also log in or register using the form near the top of this page.