<[email protected]> wrote in message
news:[email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to