It's working and I understand it :)

Thank you.

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

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