Re: [sqlite] Use of Transaction with in memory db

Sharma, Gaurav wrote:
> 1- Is there any significance of using transaction (whether auto
> commit or manual) with in memory database.

Yes. Transactions work on in-memory databases the same way they do for 
regular databases.

> 2- If the answer of first question is "yes" then second question
> would be if I wish to share an in memory db connection amongst thread
> with mutex protection. Is there required any special treatment while
> using with Transactions besides protecting them with mutex.

Again, the same considerations as for regular databases. Transaction is 
per connection: if one thread issues a BEGIN statement, all subsequent 
operations by all threads go into the same transaction.

Igor Tandetnik 



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