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 explicitly dropped, whichever comes first.

> and cannot span connections and is not locked by other connections, correct?

Correct.
-- 
Igor Tandetnik

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


[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 before returning
the connection to the pool.

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
and cannot span connections and is not locked by other connections, correct?

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