pierr wrote: > 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.
Yes. > If this is true, will this violate the isolation properity > of a transction No. > as other parallel transction would be able the see the > uncommitted change. Other transactions will be locked out while a writing transaction is in progress. For more details, see http://www.sqlite.org/atomiccommit.html http://www.sqlite.org/lockingv3.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users