Re: database design with temporary tables

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