Contents - Index

Repair/Defrag (Database=>Repair)

Choose this option to repair and/or defragment a database.

Notes:

1. "Database=>Repair/defrag" automatically does a vacuum if the unused space is > 25%. Sqlite runs quicker on most systems if there is an amount of unused space available - especially when updating and adding records to the database.

2. If space is really in issue you can force a vacuum at any time via "Database=>Totals", and click on the "compact" button