Subject Re: [ib-support] How to utilize maximum memory.
Author Helen Borrie
At 03:39 PM 13-06-02 +0300, you wrote:
>As I see now almost all RAM is unused, but Firebird create huge temp files
>during heavy "selects". It is so far to start swapping. Should I create
>RAM disk for temp files?

I truly don't know whether a RAM disk will be recognised if it is
configured as a temp sort file. I hope someone can answer you. If I had
that much RAM available on my Win box (and I don't) I would try it and
see. Why don't you try it? (And tell us the results).

If you don't know how to configure your sort space, look at the Using
Firebird manual (if you have it) in the section Configuring the Firebird
Server; alternatively, you can find similar information in the IB 6
OpGuide.pdf on a search. To ensure that FB won't do its default thing
(i.e. use the Windows TMP directory) configure things thoroughly so that
the RAM disk is the first space it uses. Make sure you also configure some
sort space on a hard disk as well (place it AFTER your RAM disk) so that
you don't blow out on big sorts.

>It looks like old ugly DOS.

And we should be surprised about that? <g>


All for Open and Open for All
Firebird Open SQL Database · ·