Hello George, I use different journal modes within the same application to different database files. My files don't all have the same protection level. Some files I turn it off completely for better speed. Others, I can't afford to lose the data.
C Thursday, August 21, 2014, 3:17:05 PM, you wrote: GI> Good evening Dr. Hipp, GI> ok, got it. Thank you for the quick clarification. GI> I only asked on the mailing list because I couldn't find this kind of GI> information in the docs (or I didn't look thoroughly enough); if it's the GI> first case, perhaps it should be mentioned somewhere... GI> Thanks again, GI> George. GI> On Thu, Aug 21, 2014 at 10:07 PM, Richard Hipp <[email protected]> wrote: >> On Thu, Aug 21, 2014 at 3:05 PM, George Ionescu <[email protected]> >> wrote: >> >> > Hello dear sqlite users, >> > >> > is it ok to mix journal modes from different threads accessing the same >> > database? >> > >> >> SQLite does not allow you to mix WAL mode with other journal modes. >> Wal-mode is a property of the database file. If you change to WAL-mode, >> then *all* database connections must go to WAL-mode. >> >> -- >> D. Richard Hipp >> [email protected] >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> GI> _______________________________________________ GI> sqlite-users mailing list GI> [email protected] GI> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:[email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
