Borehole Manager | SQLite Menu
Use the Borehole Manager's SQLite menu to perform maintenance operations specific to .sqlite databases.
- Sweep - Compact DB: SQLite database may become fragmented and non-optimal after many "hard" record updates or deletes. Use this menu item to optimize the database. This method corresponds to the SQLite VACUUM command. (http://www.sqlite.org/lang_vacuum.html)
- Analyze - Update Database Statistics: SQLite query optimizer builds a better query execution plan when it has an up-to-date database statistics. SQLite does not automatically update the statistics. This menu item collects statistics for the full database. This method utilizes the SQLite ANALYZE command. (http://www.sqlite.org/lang_analyze.html)
- Check DB File Integrity: SQLite database may become corrupted or malformed. To verify its integrity use the Check DB File Integrity menu item. This method performs the PRAGMA integrity_check command. (http://www.sqlite.org/pragma.html#pragma_integrity_check) Note, to repair a broken SQLite database, you will need to restore it from a backup.
Note also that this program checks the database at a file level to ensure that it is a valid SQLite database. This is different than the File | Check Data Integrity menu option which checks the conformity of the database structure to the RockWorks format (table setup, etc.).
Back to Maintaining your Database
RockWare home page