Re: [sqlite] Temporary tables and locking

2005-09-15 Thread Edward Macnaghten
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

[sqlite] Temporary tables and locking

2005-09-15 Thread Brandon, Nicholas
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