Translate into your language!

Vacuum Database


When an lottery is deleted from the database, it leaves behind empty space. This makes the database file larger than it needs to be, but can speed up inserts. In time, inserts and deletes can leave the database file structure fragmented, which slows down disk access to the database contents. Vacuuming the database cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure.

How to Invoke

Use the menu item "Utilities > Database Utilities > Vacuum Database" .