Hi, I have a impression that sqlite will flush the change to the disk when the page cache is full even if the "COMMIT" command has not been issued during the transction. If this is true, will this violate the isolation properity of a transction as other parallel transction would be able the see the uncommitted change. However, IMO, this won't impact the Atomic properity as we still be able to rollback if the transction would fail after the flush but before the "COMMIT" of the transction as the rollback journey is there. -- View this message in context: http://old.nabble.com/Will-sqlite-flush-the-change-to-the-disk-when-page-cache-is-full--tp26328716p26328716.html Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
