Dev4Press No Script

Ultimate Guide To SweepPress Pro and Lite

user guide 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.

Video Introduction

To see the video introductions for both Pro and Lite plugin editions, check out these articles.

The 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.

Sweep Panel Details

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. To get full information about all sweepers, and to be able to run every registered sweeper, you have the main Sweep panel.

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)

Action Scheduler

SweepPress 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.

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.

The Management

SweepPress contains several additional panels to manage various other things in WordPress and give you options to cleanup additional database tables and further improve website performance.

Options Management Panel

Options, Sitemeta and Metadata

There are three panels added for managing Options, Sitemeta and Metadata Records. These are Options, Sitemeta and Metadata.

To fully understand how the Options, Sitemeta and Metadata management works, make sure to check Usage Monitoring and tutorial about how to Manage WordPress Options Table.

Database

To manage WordPress database, review all the tables, run repair or optimization, plugin has a Database panel. Check out this article for more information about the Database Management.

WordPress CRON Control

WordPress has integrated CRON system that is used to run scheduled jobs in the background. To see all the registered CRON jobs, information about the source and more, SweepPress has a dedicated panel for CRON Control.

Additional Features

SweepPress has several optional features you can enable or disable via plugin and Expand settings. And, some features have own settings panel with extra options.

Via Expand settings panel you can have these additional features enabled and configured:

  • WP-CLI Integration: add commands to the WordPress CLI to do sweeping from the command line.
  • WP-REST-API Integration: add endpoints to the WP REST API for remote sweeping.
  • Admin Bar Integration: add menu with shortcuts to various plugin panels into the Admin Bar.
  • Log Queries into File: log all the preparation queries plugin runs into the special log file.

Settings Expand

  • Schedule Sweeper Jobs: create automatic sweeper jobs to run periodically and clean the website.
  • Sweeper Monitor: daily and weekly monitor of the sweepers status, and send email notification when predefined threshold is reached.

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.

To get overview of the plugin panels organization and navigation, check out this article.

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.

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.

Sweepers 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.

Help & Knowledge Base

Read the information on Help tabs and in the Knowledge Base to get help with the plugin. If you are not sure about any of the plugin features, reference the Help tab available on every plugin panel, or check the content in the Knowledge Base.

Rate this user guide
0
0
73

You are not allowed to rate this post.

Leave a Comment

1
0
0
0
0
0
0
0