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
