@MichaelB would you create a copy of the Testmain.db and then just write there and keep a copy. Also: have you tested if SQLite would be able to hold your data and would the database still be useable? If you have very large local databases H2 offers the option to split a DB into several local files but I do not have much experience with performance.