On 2/10/2012 2:57 PM, Marc L. Allen wrote:
MSSQL in its default serialization mode does not guarantee repeatable reads within a transaction. But, it provides locking hints to help enforce it when required. I'm guessing that sqlite does guarantee repeatable reads?
SQLite implements only one transaction isolation level - serializable (except in shared cache mode). In regular journal mode, this is achieved by holding locks. In WAL mode, this is effectively achieved via snapshot isolation (http://en.wikipedia.org/wiki/Snapshot_isolation)
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
