How do I reduce the size of my database?

The biggest culprits when it comes to large databases are the following:

  • Statistics
  • E-Mail Outbox
  • Temporary Data
  • Caching
  • Usage logs

E-Mail Outbox

The email outbox generally takes up the most space. So the easiest way to reduce the size of your database is to not save copies of outgoing emails.

Statistics

Statistics, which are useful for graphing and "quick reference" but do not affect reports, can also consume large amounts of disk space on your website. If having non-report statistics is not important to you, we recommend clearing the statatics database often:

  • Integration > Database > Clear Statistics

Usage logs

Usage logs are a history of what every employee has done throughout your administrative control panel. Electing to track usage means that a new database entry is created for every click or action. This can quickly grow in size. Therefore, if tracking employees is not a concern, we recommend turning this option off:

  • Integration > Options > "Track Usage?" = No

Temporary Data

Temporary data is stored for a variety of tasks used throughout the program. This data is routinely cleared by the cron job, however if you need to manually clear it, you can do so from:

  • Integration > Database > Clear Temp Data

Caching

Finally, if you elect to use the cache system, you can expect your database to almost double in size. Therefore, we only recommend caching for users with thousands of queries per day.

  • Integration > Options > "Use Caching?" = No

Article Links

Related Articles

Article Tags

  • No tags found.

Details

Published on 2013/08/04.
Last updated on 2013/08/04.

Was this article helpful?
Yes (0) - No (0)

Share This Article