SQLITE file size a lot issue

chuot / rdio-scanner

Rdio Scanner is an open source software that ingest and distribute audio files generated by various software-defined radio recorders. Its interface tries to reproduce the user experience of a real police scanner, while adding its own touch.

GNU General Public License v3.0

422 stars 60 forks source link

SQLITE file size a lot issue #233

Closed LoveScanner closed 2 years ago

LoveScanner commented 2 years ago

Even after manually deleting all the records in the RadioScannerCalls table the rdio-scanner database file still weighs 6G, what tool i need to run to fix this issue? (I have SQLiteStudio tool)

Edit: I found a solution to run a query vacuum Now only 50MB maybe a radio scanner should run it once in 24 hours

chuot commented 2 years ago

Please see issue #169.

Rdio Scanner will never manage VACUUM by itself as it brings a lots of other issues.