|Subject||Re: Empty table optimization|
>Actually i do calculations on temporary table. In general there is not significant speed difference between persistent and temporary tables in my case.
> 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.