Temporary tables are limited to an individual connection and are deleted
when the connection closes.
You should not be accessing the same connection by two different
threads, if you do then you must not do so simultaneously but to use a
MUTEX lock. With that in mind any locking on the temporary table is moot.
Eddy
Brandon, Nicholas wrote:
Hi
I don't think I fully understanding the locking strategy with temporary
tables. The documentation at
http://www.sqlite.org/cvstrac/wiki?p=MultiThreading suggests that Temporary
tables are not locked like the normal database.
If you can read and write to temporary tables and their is no locking
mechanism, then I assume the scope of a temporary table is restricted.
Is the scope of temporary tables within a thread or a process?
Regards
Nick
********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************
