The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted (particularly in master files such as the Batch file). New records are always added to the end of the file. Therefore, over a period of time, it is possible a file may appear full but there could be gaps in the middle where records were deleted. Using this option consolidates the active data and frees up space.
This option effectively re-arranges all the active records so you must run both the ‘Audit Pointers’ functions after using this option. In practice you are unlikely to use this option unless you have manually removed batch records or transactions – the clear down processes within batch tracking running the compact process.
Article ID: 562
Created On: Tue, Jun 19, 2012 at 3:53 PM
Last Updated On: Thu, Jun 22, 2023 at 10:38 PM
Online URL: https://kb.datafile.co.uk/article/compact-audit-database-batch-tracking-562.html