Hello Everybody!

Here is my deal… I need to force FB 1.5 to use real more memory
instead of using swap files. We have huge databases 15-30 Gb in
size. Up to this point we were using Free IB 6. Everything worked OK
until we had been forced to run IB on Win2003 server. Somehow IB did
not want to behave and we decided to try FB.

FB 1.5 runs absolutely fantastic on Win2003 but now we have problem
on Win 2000 servers. Our servers have 2 processors and 1-2 GB of RAM.
With IB we were using SERVER_WORKING_SIZE_MIN and
SERVER_WORKING_SIZE_MAX parameters in ibconfig file to engage more
memory . With FB 1.5 we do not have those parameters. When we are
trying to restore 22 GB database with a lot of indexes Firebird is
insisting on using only about 72 meg of real memory and along with
that it creates enormous activity in the swap file ( a lot of page
faults ). There is plenty of memory available and we also
proportionally (16 times) increased SortMemBlockSize and
SortMemUpperLimit as well as Database_Cache_Pages (4 times).

How do we make Firebird to use more real memory?

Thanks,

Tim