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.

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

> Hi,
>
> In a Windows XP 32 bits, with Firebird 2.5 SuperServer:
>
> If i want to increase the amount of RAM available for Firebird, the only
> way is with DefaultDbCachePages? And because the max value is 131072, can't
> i increase the ram to more than 1GB for a page of 8192?
>
> Is the FileSystemCacheThreshold another option to do that, but with OS
> cache?
>
> Thank you.
>

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