[Mackx]

Originally Posted by dima_tr

Hehe, it is possible to add autovacuuming using the approach described here http://www.friday.com/bbum/2007/03/0...#comment-81574

Seems to be easily done by operating global.db on local Linux machine.

Another way is to recompile libsqlite to have autovacuuming on by default (now it is off). http://www.sqlite.org/compile.html#default_autovacuum

I am not sure how long vacuuming takes, I think even auto vacuum, rewrites the complete file, so it could cause unpredictable delays. I am not sure if this works well with the idle-mechanism of the DR.
Maybe an extra item in Settings (or a simple application or script) to maintain global.db (and all the metadata.db) files. Allowing to do an integrity check and a vacuum?