My database is getting big. How do I reduce the file size?

Note: Before you begin, back up your existing database file (CWNPSQL) through the Tools > Database Backup Scheduler > Run now.


Delete Bandwidth Data

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

Delete other data 

Use the Delete URLs option to delete URLs from your database before a specific date.

  1. Open BrowseReporter from the left-hand side.
  2. Choose Delete Data button from the menu bar.
  3. Choose the checkboxes to delete URLS, Bandwidth and/or Application data.
  4. Choose the PCs or Users.
  5. Select the Period.
  6. Press Delete Data.
    • Note: The deletion of data is permanent.
  1. Choose the checkboxes to delete URLS, Bandwidth or Application data
  2. Choose the PCs or Users
  3. Select the Period
  4. Press Delete Data.
    • Note: The deletion of data is permanent.

Compress your Database (Firebird Database Only)

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.

database-compress-2018-11

Enable the Auto-Delete URL Scheduler to clean up your database periodically

Enable this option to clean up your database automatically. When enabled, BrowseReporter will only keep data from a period of time. You can define how long you want to keep data.

  1. On the CurrentWare Web Console, go to Tools > Auto Delete Scheduler.
  2. Enable the scheduler.
  3. Select the tracked data types you want to delete automatically.
  4. Choose the number of days you want to keep the tracked data for.
  5. Decide on the start time each day to perform the data deletion.
  6. Select to Apply the Auto Delete Scheduler in the bottom-right corner.
Auto Delete

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. You can define how long you want to keep data.

auto-delete-scheduler

Enable the Database Backup Scheduler

Enable this option to begin automatically backing up the CurrentWare database on a daily, weekly or monthly basis.

  1. From your CurrentWare Web Console choose the Tools option
  2. Select Database Backup Scheduler from the menu.
  3. Choose to Enable Scheduler.
  4. Select your Backup Path, Schedule (Daily, Weekly, Monthly) and the Start Time.
  5. Apply the scheduler by hitting the Apply button in the bottom right corner.

Go to Tools > Database Backup Scheduler. Enable this option to begin automatically backing up the CurrentWare database on a daily, weekly or monthly basis.

backup-database-scheduler

New to CurrentWare? Get Started Today!

“I chose CurrentWare for the solid product that gave more options with a lower price tag, high accuracy, and solid customer support.” -Vincent Pecoreno Network Administrator, Viking Yachts