Database Clean Up

Over a period of time redundant data may build up in the database as a result of changes to templates etc. Identifying and removing this data automatically each time processes are run has in the past led to performance issues. The Clean up tool allows the database to be cleansed by an administrator at a time that suits you. To minimise the effect on users it is recommended you run the tool when no other users are logged in to the database.

Clean the database as follows:

  1. Login as an administrator after having first checked that no other users are logged in.
  2. Select Tools | Database Cleanup from the menu to view the redundant items.
  3. Click OK to run the clean up process.