My main goal - to avoid blocks and interruptions in this two scenarios.
Thanks for "vacuum into" - I will test that.
Is the "foo.db" in Scenario 1 the same "foo.db" in scenario 2 or do they just have the same name by happenstance?
Or the same database of different machines or something?
Yes. Same db, different machines. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users