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