Cross Section Viewer

Compact Database

The Cross Section Viewer database file size will grow automatically to accommodate new data. However, the file size will not decrease as data are deleted. This is typical among popular database technologies and in most cases should not present any operational issues.

Over time, or in the event that large portions of data are deleted (e.g. surveys with thousands of cross sections comprising millions of survey points), the underlying Cross Section Viewer database might become fragmented with the “gaps” where data have been removed.

SQLite provides a convenient vacuum process for releasing the unused space and compacting the database file to it’s optimum file size. You can vacuum the current Cross Section Viewer database using the Compact Database menu option in the main File menu.

compact)

Note that you should be the only user of the current Cross Section Database when you perform this operation. All other users and software should disconnect and avoid using the database in question until the vacuum operation has completed. SQLite does possess sophisticated locking and queuing procedures taht will prevent file access conflicts, but it is best to have exclusive access to the database when performing this option.