[sqlite] Use of in memory db

Hi All,

Is there any way through which without using the mutex lock mechanism multiple 
threads can perform INSERT in bulk on same memory db. What I assume is if I 
share an in memory db connection handle across threads then it will not be 
sqlite's responsibility but the user's responsibility to protect multiple 
insert/update statements. On the other hand if the connection to physical db is 
shared amongst threads then sqlite takes care of synchronization between 
multiple insert/update from multiple threads.

Basically a broader question is that, Is there any way to avoid sharing of 
connection handle and even then be able to work on the same memory db from 
multiple threads. I really wish to avoid the burden of using mutex for every 
(insert or update) in multi threaded scenario. That actually supposed to put 
lot of overhead on my application.

Or any one can suggest how best the mutex can be used if I share the connection 
and then perform transactions (insert, update).

With Best Regards
Gaurav Sharma


The information contained in this electronic mail transmission 
may be privileged and confidential, and therefore, protected 
from disclosure. If you have received this communication in 
error, please notify us immediately by replying to this 
message and deleting it from your computer without copying 
or disclosing it.


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