At 07:03 PM 27/06/2008, you wrote:

>Hello,
>
>Is my understanding correct that the Sort Files are created when a
>query result large amount of data?

No. Sort files are created when an intermediate structure for a sorted set (order by or group by) is too big to fit in available memory.

>Does Firebird create any other temporary files?

No.

>Is it possible to completely deactivate usage of the Sort Files?

No. Well...if you don't do any order bys or group bys, you won't get any sort files. ;-)

>I'm using Firebird 1.5.3 on Win32.

./hb