Archiving

With use the dPos database tables containing sale and transaction details can become very large and will eventually slow down both initial loading and operation of the system. Old information that is no longer needed can be cleaned out of these tables by archiving the current tables and then specifying a date before which data may be regarded as old and no longer required for immediate access.

To archive the database push the Archive button in the Setup & Maintenance screen. This archives the current database to the Archives folder, naming the file with the current date in the format yyyymmdd.mdf (and the associated log file). When archiving has finished the following message is displayed:

 

 

If you respond by pushing the Yes button the Database clean out screen appears:

 

 

This offers to remove all entries from the current sales and transaction tables dated before the date displayed. By default the date displayed will be one year before the current data.

If you wish to proceed you need to check the checkbox to indicate that you understand that you are deleting data and then push the Purge Database now button. Purging can take some minutes if the database has become very large, but you will receive one further warning indicating the number of sales records that will be deleted:

 

 

Pushing the Yes button starts the process and the status box informs you of progress and indicates when the process has finished.

 

 

More:

Revisiting an archive