|
The Purge and Backup module is aimed at high volume stores that periodically need to clear the database of old data and keep your store running smoothly.
The osCommerce database structure contains many tables which if left unmaintained can dramatically slow down your store. When a customer places an order a minimum of 7 tables are updated, some of these entries will contain many rows of data. After many years of busy trading all of this old data can cause performance problems with your store and customers may experience slow downs while placing orders.
Our Purge and Backup module allows stores owners to safely remove old entries from the database and optionally store them for future reference. Store owners can choose a period of time in which to purge data or for a more automated process can create a cronjob scheduler job to automatically backup and purge data every month.
Two purge options are available, customers or orders. If orders is chosen then all orders older than the selected period will be purged, alternatively if customers is chosen then all customer accounts within the selected period are purged from the date the customer last logged in.
The module has built in server protection and in the event of a high server load the script will automatically pause until the load reduces to a reasonable level.
|