so if stmt1 & stmt2 are executed on different threads , but on the same connection, they would not block each other?
Sreekumar On Feb 6, 2012 8:08 PM, "Igor Tandetnik" <[email protected]> wrote: > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
