Subject Re: [firebird-support] Temporary directories
Author Ann Harrison
On Aug 20, 2013, at 7:14 PM, Hugo Eyng <hugoeyng@...> wrote:

> Something like: "If I have a lot of RAM available, how could I use it in
> a way to increase the database speed (specially queries)".
> I found out that chaging DefaultDbCachePages from 75 to 750 the queries
> really run faster.
> Using a ram disk drive increases a query that uses ORDER BY or GROUP BY

If your default cache size is 75, then you're not using SuperServer with its shared cache. Even with a cache per process, 75 is very small for a modern machine. In general, database cache is a good place to use memory. A RAM disk for temp space will help when the query requires sorting (order by, group by, distinct) but not much otherwise.

Good luck,