Deon Brewis wrote: > What is the level of consistency (or rather inconsistency) for > read_uncommitted?
In read_uncommited mode, read-only transactions to not take the database file lock. However, most sqlite3_xxx() function calls still lock the in-memory database object(s) (this is required for any multi-threaded accesses), so other threads can see only the complete changes made while a lock was held. In particular, sqlite3_step() takes a single lock around all VDBE statements it executes, so what you end up with is statement-level atomicy. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
