Subject Re: [firebird-support] memory allocation issues
Author Ann W. Harrison
Robert martin wrote:
>
> We have a machine running Win XP with 3GB Ram. It has a 1.5GB DB with
> 8192kb pages and buffers set to 20000 (was a super server DB). It has
> been running FB 2.1.3 SuperServer however performance has been
> terrible. This morning I changed it to 2.5 super classic.

SuperClassic has separate caches for each connection. Cut your
buffers back to >1000 and things will be better.

Good luck,

Ann