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