openerp-expert-framework team mailing list archive

[Xavier Morel <xmo@xxxxxxxxxxx>]

On 10 Feb 2010, at 16:45 , Christophe Chauvet wrote:
> 
> The TEMPORARY TABLE are create in RAM if the temp_buffer parameter is
> sufficient if not, the table is store on the disk
> 
> Christophe.

There are no guarantees they'll be created in ram, even if temp_buffer is big enough, unless the temp_tablespace is on a ramdisk. And even if they are created in ram, temporary tables DDL will more than likely need to update system tables which are stored on disk. So temporary tables will incur disk hits either way.

See http://old.nabble.com/Create-and-drop-temp-table-in-8.3.4-td20347767.html for (among other things) mentions of these.

--
Xavier