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" <itandet...@mvps.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users