But if i set TempBlockSize or TempCacheLimit to 0, to allow only on disk
sorting for testing purposes, Firebird should create temporary files in my
temp directory isn't it?

I mean that i would like to understand when Firebird does RAm sorting and
when does disk sorting.

2011/6/6 Jesus Garcia <jegaza@...>

>
>
> 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]
>
>
>

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