> about the sort/temp space, i try in Firebird to configure
> TempDirectories = g:\fbdata\temp
> but i never see any files in it !! the directory is always empty ... is it normal ? (and their is millions queries everydays on the database)

It depends on queries. If they are sane, it is normal. Perhaps, their
result sets are small enough to always use in-memory sorting. Or they
are too fast, so files are deleted before you notice them.

SY, SD.