On Wed, Mar 27, 2013 at 8:05 AM, Jeff Archer <
[email protected]> wrote:

> If all connections (1 per thread) of all processes (multiple simultaneous)
> issue command "PRAGMA journal_mode = off", is access to a common database
> file located on the local machine still synchronized correctly between the
> random accesses (reads and writes) occurring across all?
>

Yes.  The journal handles rollback and atomic commit (both of which you
lose when you go to journal_mode=off) but isolation is handled with file
locking on the original database file.

-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to