Re: [sqlite] Understanding temp tables

2011-02-07 Thread Igor Tandetnik
On 2/7/2011 8:30 PM, Sam Carleton wrote: > Assuming the connection pooling works correctly, it is my understanding that > there is absolutely no way for another request to mess with that temp table, > correct? In other words: a temp table lives for the life of a connection ... or until

[sqlite] Understanding temp tables

2011-02-07 Thread Sam Carleton
I am using SQLite in a Apache module on Windows. On Windows, Apache is a single multi-threaded process. The Apache DBD is used to leverage connection pooling. At one point in the code, the web request gets a connection, creates a temp table, used the temp table, and then deletes the temp table