Sorry It is called vacuum not compact (found my old post)…
The easy way to vacuum the database is to put dude.db and sqlite3.exe in the same folder then make a shortcut to sqlite3.exe, edit the properties of the shortcut so that dude.db is on the command line.
“C:\user\guy\Desktop\sqlite3.exe” dude.db
Then double click the shortcut, type VACUUM; A journal file will be created while it is vacuuming… I think that is how, it is still running ![]()
And raw keep time is Settings, Chart.
HTH,
Lebowski