Hi, all! I wasn't able to find clear answer to my question about locking in sqlite in documentation, so please help me who knows things well. Let's say we have 3 different connections, all created with the same pattern: connect to database A, attach database B, attach database C. Then in these 3 connections we execute these 3 statements:
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? Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
