a kind of Edit->Optimize database to export current/switch to new/remove old database.

recently, my database was broken, so, using sqlite3, I dump the current dabase to sql, import it the a new one, then switch the current and hte new one.

In fact, the advantage of doing this was that cleaning database was far more faster (a couple of tens of minutes for series) than before (several hours) !

manual actions taken :

$ sqlite3 MyVideo46.emm
pragma integrity_check;
.output MyVideo46.sql
.dump
.exit
$ sqlite3 MyVideo46.emm.new < MyVideo46.sql
$ mv MyVideo46.emm MyVideo46.emm.$(date +%Y%m%d%H%M%S)
$ mv MyVideo46.emm.new MyVideo46.emm

then clean MyVideo46.emm.$(date +%Y%m%d%H%M%S) whenever you want.

PS : don't know how .PRAGMA optimize may be helpfull in this context ? nothing to do here, but, do you "PRAGMA shrink_memory;" sometimes to free up memory ?