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.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com