Subject Re: Empty table optimization
Author tomjanczkadao
>
>
> if IIRC TEMPORARY TABLES are stored in memory, so you can make temporary
> computation on a temporary table.
> Because TT are can be cleaned on commiit, you need to delete at the end
> of each FOR SELECT cycle, but writes are not performed to/from disk.
> Expecially if your db has forced writes this can give a performance boost.
>
> Ciao.
> Mimmo.
>

Actually i do calculations on temporary table. In general there is not significant speed difference between persistent and temporary tables in my case.

Regards, Tomek