Hello.

I am trying to increase the speed of my queries.

Firebird 2.5
Windows Server 2008
32 GB RAM

I use 10GB of ram as a "ram disk drive".

I wrote query that takes 2:45 minutes running _*without*_ the
TempDirectories=R:\TEMP (ram disk drive)
and the same query takes 1:13 minutes running _*with*_ the
TempDirectories=R:\TEMP (ram disk drive).

I tried to set the FIREBIRD_TMP environment variable instead of the
TempDirectories and it doesn't work as I expected.
I guess that I could use TempDirectories _*OR*_ FIREBIRD_TMP.

Another question is that using a ram disk drive increases only queries
that uses ORDER BY or GROUP BY.

Does somebody has comments, suggestions?

How to really increase the speed of my queries using RAM, a lot of RAM?

--


Atenciosamente,

Hugo Eyng



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