Re: Performance of the temporary table creation and use.

On Tue, Jan 25, 2005 at 03:29:55PM -0800, Dann Corbit wrote:
> If you store the temp tables in RAM, how will you preserve the ACID
> property on power failure (without using write-through which would
> negate the speed advantage)?
> 
> The temp tables may be participating in a transaction.

Temp tables are only visible inside a single session. They are
inherently not durable. 
-Mike Adler