On Apr 29, 2009, at 10:03 PM, James Gregurich wrote:

> howdy!
>
> question:
>
> for an in-memory db with the threading mode set to serialized, is the
> internal mutex held for an entire transaction so that one thread won't
> access the db while another one is in the middle of a transaction with
> multiple insert statements?


No.  But the mutex is recursive.  So you can get a copy of it using  
sqlite3_db_mutex() then lock it yourself using sqlite3_mutex_enter()/ 
leave().

Also remember:  You should not be using threads.  Threads will bring  
only grief and woe.  On your own head be it.



D. Richard Hipp
d...@hwaci.com



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

Reply via email to