ma_golyo wrote:

> Hi!
>
> Temp dir is used only when there is not enough free memory for dataset ordering (ORDER BY or GROUP BY).
>
> --- In firebird-support@yahoogroups.com, "trskopo"<trskopo@...> wrote:
>> Hi all,
>>
>> I set temp directory for firebird 2.5.1 Super Server in firbird.conf like this :
>> TempDirectories =e:\;d:\temp
>>
>> On Win 7 64, also set environment like these :
>> - FIREBIRD_TMP = e:\;d:\temp
>> - TEMP = e:\
>> - TMP = e:\
>>
>> How do I know, firebird using that temporary directory?
>> Running a few query via flamerobin, seems that firebird not using that directory.
>>
>> Thanks and regards,
>> Anto
>>

Hej, simply point your tempdir to something non-existant and try to
restore a database. It will stop at the end and you'll not getting it done.
That's what the temp dir is used for, too.

hth, Marcus