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@xxxxxxxxxxx
