Hi Jan,

> > These config paramaters and sort in RAM, written and added by
> > D.Yemanov a few years ago.
>
> I don't understand. These are not FB parameters? They are in the

FB

> config file... (and seem to have an effect on the amount of memory

FB

> allocates)?

This parameters to intend to sort in RAM instead of temp DISC file.
in your setting FB will try to allocate 1 GB RAM for each sort
attemt. also, you using Classic server, not so much friendly with
system resources.
I don't think your performance problem can solve via sort
parameters. if you have good indexing and good queries then even
your FB don't need so much sorting.

Here is our one of customer:
xeon 2.8 (sorry AMD, it was not my choice)
Linux 32bits, Fedora C2, 1 GB RAM, 3.5 GB FDB file, FB SS. 1.5.2
125 clients, 230 active connection..
It is a state hopital with heavy duty. There is no any performance
problem.

>
> My luck has run out with 8GB. Server memory banks are full and

available

> budget has been all used. Should get me a long way though...
>
> cheers!
> Jan
>

:) believe me 8GB is a paradise in any case for a 15 GB database.

Regards.
Ali