Evaluating Free Space

This utility will analyse database files and report on the amount of free space remaining in the database files. It is generally used as a pre-requisite to the Compact files utility. If the output of this process indicates that there is free space found in the database files, the Compact process may be run to optimise the use of space on the serve.

To run this utility, select Evaluate Free Space from the Operation menu. Click the Add All option to select all database files for evaluation, and click OK to process. While this operation running, a progress dialog displays to the form that enables you to monitor the progress of the operation. Click Cancel to abort the run. When the operation is finished, this message displays:

Free space evaluation complete

This process generates a file called fspace.log, which is output to Greentree Desktop directory. An example of the fspace.log file is shown here:

2018/01/17 14:58:53 Free Space Evaluation for file: _stats [13] commenced

0 - bytes of free space found in file

2018/01/17 14:58:53 Free Space Evaluation complete

2018/01/17 14:58:53 Free Space Evaluation for file: _system [21] commenced

387405 - bytes of free space found in file

2018/01/17 14:58:54 Free Space Evaluation complete

2018/01/17 14:58:55 Free Space Evaluation for file: _sysxrf [22] commenced

941204 - bytes of free space found in file

2018/01/17 14:58:57 Free Space Evaluation complete

2018/01/17 14:58:58 Free Space Evaluation for file: _sysgui [23] commenced

1666047 - bytes of free space found in file

2018/01/17 14:58:59 Free Space Evaluation complete

2018/01/17 14:58:59 Free Space Evaluation for file: _sysint [24] commenced

0 - bytes of free space found in file

2018/01/17 14:58:59 Free Space Evaluation complete

This example indicates that there is free space in the _system, _sysxrf, and _sysgui files, which makes running the Compact utility across the database worthwhile.