SNIP
>> processed by a complied virtual machine.  Threads switch at the
>> machine code level, so a thread could switch between the processing
>> of the 'g' and the 'i' of the first 'begin'.
>>     
>
> SQLite actually maintains a mutex per connection. Every API call 
> acquires this mutext and keeps it for the duration of the call. Thus no 
> two calls can proceed simultaneously on the same connection.
>
> So no, another thread cannot interfere while sqlite3_prepare call 
> advances from 'g' to 'i'.
>   

I stand corrected.


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

Reply via email to