>In PERSIST mode, you have two files associated with your database >instead of one. Whenever you move, copy, or rename the database file >you *must* also move, copy or rename the journal file to prevent >database corruption. > >The persistent journal file uses disk space that might otherwise have >been returned to the operating system and made available to other >programs.
Say I have a database open in PERSIST mode for fast operation. Before the app shuts down, I would like to detach the database of its journal file (to free some storage space and guarantee a self contained, single file database). Will a simple "PRAGMA journal_mode=DELETE" do this for me and automatically delete the journal file when (or even before) I close the database? Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users