When your CurrentWare database size is larger than 3 GB, the performance of your CurrentWare Console will become slower.
To optimize the performance, we recommend deleting old data and compressing your database.
Note: Before you begin, back up your existing database file (CWNPFB.CWD) to safe location.
#1 – Delete Bandwidth Data
(Delete Bandwidth Data is available from version 5.3.3 and above)
Bandwidth data takes up a majority of your database. Deleting Bandwidth data will save you the most space. Here are some of the options:
If you are not running Bandwidth reports:
- Delete all Bandwidth data: this will reduce your database size by more than 50%.
- Disable Bandwidth tracking: go to Tracking Options and uncheck “Enable Bandwidth Tracking”
If you are running Bandwidth reports:
- Delete data before a specific date: delete data to reduce the database file size
- Decrease Bandwidth data tracking: go to Tracking Options and change the “Discard data less than” value to 10 KB
#2 – Delete other data
Use the Delete URLs option to delete URLs from your database before a specific date.
#3 – Compress your database (mandatory)
After deleting your data, you must compress your database to reduce the file size.
Launch the CurrentWare Server manager (CWSM.exe) from Start menu > All Programs > CurrentWare > CurrentWare Server Manager. Click on the Compress tab.
Browse to the CWNPFB.cwd file inside \Program Files\CurrentWare\cwServer and click on the Compress button. The database will be compressed to reduce file size.
#4 Enable the Auto Delete URL Scheduler to clean up your database periodically
Go to Tools > Auto Delete URL Scheduler. Enable this option to clean up your database automatically. When enabled, BrowseReporter will only keep data from a period of time that. You can define how long you want to keep data for.
#5 Enable the Database Backup Scheduler
Go to Tools > Database Backup Scheduler. Enable this option to begin automatically backing up the CurrentWare database on a daily, weekly or monthly basis.