Ultimate Guide To SweepPress Pro and Lite

SweepPress is a comprehensive set of tools for cleaning up the WordPress-powered website, getting more insight into some inner workings of the website, and other useful things to help you keep your website well maintained and free of unused data slowing down the website.

And indeed, the way the database works, depending on various factors, database queries get slower with larger datasets they need to work with. While database engines can use various query optimization techniques, it is always a good idea to remove all the data you don’t need or the data that can’t be used from the database. And, due to various factors, many WordPress tables can be filled with records that are not linked to anything and can’t be accessed or with data that you no longer need. Removing all that will help your server and database to run queries faster.

SweepPress Sweepers

SweepPress is a plugin that is built to handle large number of different sweepers, and the plugin currently has over 40 sweepers included in the Pro version. But, not every sweeper is registered by the plugin on every website. Some sweepers are made for third party plugins, and some sweepers can be disabled from registration.

Included Sweepers

All the sweepers are categorized into many categories, and loaded only when they can be used. To see the list of all the sweepers, listed by category with additional information about each sweeper, check out this article.

Supported Plugins

Currently, SweepPress supports cleanup of data for the database tables added by these plugins:

  • BuddyPress: 4 Sweepers
  • GravityForms: 3 Sweepers (only in SweepPress Pro)

And, plugin contains 5 more sweepers for the ActionScheduler database tables. ActionScheduler was developed for WooCommerce initially, but since, a lot of other plugins include it and use it, so these sweepers can help with large number of popular plugins that depend on the ActionScheduler.

Other Dev4Press Plugins

Currently, all Dev4Press plugins that add database tables include tools to maintain those tables and run cleanups. If any Dev4Press plugins needs additional help with that, support will be added to the SweepPress plugin.

Best Practices for using SweepPress plugin

SweepPress is a powerful plugin, and it can do a lot to clean up your WordPress-powered website database, but this is a plugin that removes data from the database, so you should make sure to understand properly how to use it, what the best way is to use the plugin, and maintain your database.

Before you go on, make sure to go through the plugin user guide and follow articles about various plugin features. The list of recommendations listed here will be expanded over time, so make sure to check out this article from time to time to get the latest in the best usage practices.

Database Backup

Make sure you have regular database backups in case you remove some data that you later want to get back. SweepPress doesn’t back up your data and can’t restore it once it is removed! Database backup is up to you!

Database Optimizer

Do not run the Database Optimizer sweeper too often; once every few months is enough. This sweeper runs server-intensive operations that can also take more time to finish; they can even recreate the table and copy the data to ensure it is optimized.

Sweep Information

Make sure to read all the information provided for each sweeper to understand it better. Each sweeper has a lot of information provided on the plugin Sweep panel, including limitations and a list of affected database tables.

Important Notices

Sweeper Estimation

Plugin uses elaborate SQL queries to determine and estimate what needs to be removed. All these estimations are just that: estimations, and they are not 100% precise. For an actual number of affected/removed records, the size of the data may differ from real results, and the difference can be in the range of -20% to +20%. Plugin queries are adjusted with every update to make the estimation process better.

Having 100% correct size and records calculated is impossible without removing the data and calculating the difference, so the estimation is the best that can be achieved.

Plugin Interface

SweepPress uses the same interface as all other Dev4Press plugins for WordPress, based on the same look and feel, with some distinct colors this plugin. The plugin top-level menu in the WordPress administration and that panel have several pages. The pro plugin version has more panels for some exclusive tools.

The Dashboard

The Plugin dashboard is a starting point for using the plugin, and it serves as a status display, includes options for Auto and Quick Sweep, and buttons for some of the plugin panels.

Dashboard Panel

The Plugin Status area shows a useful overview of things. It shows the status of some of the additional modules, monitoring, log file, total number of active sweepers, and registered jobs. Auto Sweep box allows you to run sweeping with one click of the button or via the Quick Sweep Mode.

The Help

SweepPress integrates into the WordPress Admin Help system, available via the Help tab on the top right of the page, just underneath the main toolbar. If you open this Help tab on SweepPress panels, you will get a lot of helpful information about each panel that can help you with using the panel and guide you with the sweeping process.

Help Tab

It also has some useful links to the official website for the plugin, links to support, links for opening new support topic in the forums, and more. Make sure to check out this aspect of the plugin.

The Settings

It is very important to have the plugin properly configured, and you can do that from the Settings panel. Check out this article to learn more what settings you can modify and how you can improve the SweepPress for your website. All settings are available on the Settings panel.

The Sweepers

SweepPress includes a lot of different sweepers. Some sweepers have specific system requirements and will not be available for every website. If you use normal WordPress installation, network (multisite) related sweepers will not be available (but they are still registered), and if you don’t have Gravity Forms plugin, sweepers for it will not be registered at all.

All sweepers are split into several categories, and they are all listed in the separate article.

The Modules

SweepPress has several optional modules you can enable or disable via plugin and Expand settings.

Settings Expand

The Additional Features

SweepPress Pro comes with several additional features that can be very useful. You can schedule automatic sweeper jobs to run periodically and clean the website with Scheduled Jobs; you view and review all the tasks/jobs registered in WordPress CRON; or you can review all the Database tables for your WordPress installation.

Rate this user guide

You are not allowed to rate this post.

Leave a Comment