<souvik.da...@wipro.com> wrote in message
news:61c4c33b211cd64ebf4b6eb0d03dd56e20d...@blr-m3-msg.wipro.com
> I have an application that requires two threads to insert data into
> the database simultaneously ( both the threads are updating
> independent tables which are in the same database).

http://sqlite.org/sharedcache.html

Normally, SQLite locks the whole database on write, so two connections 
can't write simultaneously. But in shared cache mode, SQLite supports 
table-level locking, so two connections could write simultaneously to 
different tables.

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to