On 3 May 2012 20:29, Harnek Manj <hm...@gemcomsoftware.com> wrote: > Hi Simon, > > Yes I have multiple Threads which are accessing the database. Currently if I > am doing a write operation the whole database file is locked, I want the > locking applied only to the table in operation. > > So currently from .net code I just say BeginTransaction(ReadCommitted) and do > a write operation this locks the complete database file and the write > operations are really long. So currently I want to solve the > locking issue by bringing them down to table locks.
http://www.sqlite.org/whentouse.html look at last paragraph - SQLite locks the whole database file. > > You mentioned "BEGIN EXCLUSIVE TRANSACTION", but I don't see where I can set, > that I want to start a transaction with exclusive lock, when I call > BeginTransaction on the connection. > > Thanks > Harnek > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users