So if A, B and C are different files then they will not block despite leaving inside the same connection, right? BTW, by "block" I mean retrying after SQLITE_BUSY too. That's very good and convenient thing.
Thank you, Pavel On Sat, May 2, 2009 at 10:05 PM, Nuno Lucas <ntlu...@gmail.com> wrote: > On Sat, May 2, 2009 at 3:48 PM, Pavel Ivanov <paiva...@gmail.com> wrote: > [...] >> update main.t set x = 1 >> update B.t set x = 1 >> update C.t set x = 1 >> >> My question is will these statements be able to execute in connections >> in parallel simultaneously because they use different databases and >> should lock only those databases? Or they will lock each other and >> will exhibit effectively serial execution because main database in all >> connections is the same? > > The lock is per database file, so they will only block (or fail with > SQLITE_BUSY) if done at the same time on the same database file. > > Regards, > ~Nuno Lucas > >> >> Pavel > _______________________________________________ > 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