Subject | Re: Empty table optimization |
---|---|
Author | tomjanczkadao |
Post date | 2010-10-05T13:27:54Z |
>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.
>
> Ciao.
> Mimmo.
>
Regards, Tomek