Sreekumar TP <sreekumar...@gmail.com> wrote: > well, if stmt1 is a write transaction, it would aquire an exclusive lock. > if stmt2 is a read transaction, it would fail acquiring a shared lock
The concept of a transaction exists on a per-connection basis, not per-statement. Transaction isolation applies to statements running on two separate connections. Multilple statements running on the same connection never block each other. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users