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