--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@...> wrote:

> What's the page cache/buffers of the database(check it by using GSTAT
> to retrieve the database headers)? It sounds like the page cache is
> set at a high value, but with Classic I would recommend that it would
> be set to 75 pages.
>
>
> --
> Best regards,
> Daniel Rail
> Senior Software Developer
> ACCRA Solutions Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>

I just logged onto their server and checked some of the settings. These three settings were uncommented and seem like they are the culprits of the performance issue:

DefaultDbCachePages = 16384
LockMemSize=16777216
LockSemCount=256

What are the recommended settings for these values in Classic mode (obviously 75 for the cache pages as you've already mentioned)?

Thanks,
Ryan