Please log in to bookmark issues
EMM-186 – 
Feature request
Click to toggle a vote for this issue
0 + 0
Time tracking started at Paused
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
$ sqlite3 < MyVideo46.sql
$ mv MyVideo46.emm MyVideo46.emm.$(date +%Y%m%d%H%M%S)
$ mv 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 ?
How to reproduce
Expand, collaborate and share
Post a comment and get things done
Important details
User pain
  • Type of bug
    Not triaged
  • Likelihood
    Not triaged
  • Effect
    Not triaged
Times and dates
  • Estimated time No time estimated
People involved
Other details