Re: database design with temporary tables

On 8/29/21 10:41 AM, Mladen Gogala wrote:
> 
> On 8/29/21 12:24 PM, Adrian Klaver wrote:
>> Presumably not. Temporary tables only live at most for the length of a 
>> session. It would be a really bad idea to hold sessions open for 24 
>> hours. That is assuming nothing else causes the session to drop and 
>> the data to be lost. 
> 
> Well, that's precisely how application servers work. The allocate 
> connection pool and keep them open for a very long time.

The pool is maintained, the individual connections(sessions) come and 
go. Otherwise there would be no point to having a pool. Every time the 
connection(session) is closed the temporary table disappears.


-- 
Adrian Klaver
adrian.klaver@aklaver.com