Hi,

kettch_19 írta:

> --- In firebird-support@yahoogroups.com, Daniel Rail <daniel@...> wrote:
>
> I sent a reply to this previously but it hasn't appeared in the list so I'll try again...
>
> The settings that I am questioning are as follows:
> DefaultDbCachePages = 16384

This is your problem. In example if your database page size is 16384 the
used memory is 16384*16384/client/database. So only for page cache used
256MB/client/database.

> LockMemSize=16777216
> LockSemCount=256
>
> What would be reasonable values for these? It appears that since this is a Classic server that it is set to try and allocate all 16GB of memory right away which would obviously cause problems.

I suggest calculate from the number of clients, database page size, etc.
and think for TempCacheLimit too. And the OS need some memory also. ;-)

>
> Thanks,
> Ryan

Gabor