Sreekumar TP <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
