2011/6/6 Jaume Llunell Gómez <jaumellunell@...>

>
>
> Another question, when does Firebird uses Temporary Directories insted of
> RAM?
>
> For example, if i have a table with 3 Gb of data and i make a select
> count(*) from table order by id or select sum(quantity) from table group by
> id... this should sort the result set, but isn't it done at disk in a
> temporary file?
>
> I can't see any file in my temporary directory while this is happening.
>
> I'm asking because i have few databases of 0,5 GB , 1GB , 3Gb , 5 Gb ...
> and
> from 0,5 to 3 Gb it scales quite normally in some orders and group by
> querys
> ... but the 5 Gb the execution time is quite bigger. So i don't know if the
> sorting is done in memory in each case or not.
>
> Thank you.
>

You can crate a RAM DISK and set in firebird.conf to use it as temporary
path/disk.
Jesus


[Non-text portions of this message have been removed]