Subject Re: [Firebird-Architect] "Large Address Aware" - giving 3-4 GB of virtual memory to 32bit FB
Author Ann W. Harrison
Kirill S. Palagin wrote:
> Given current state of affairs with IB I have to go after low hanging
> fruits, i.e. increase page cache to highest allowed by IB/FB/Ya.

Let me emphasize the point Sean made just a bit. If you're using
Firebird 1.x, a page cache larger than about 8K pages hurts performance.
InterBase found and fixed the problem a bit earlier, and it's fixed
in Firebird 2. Don't use cache sizes larger than 10K pages in
Firebird 1.x or InterBase before 7.0.

Regards,


Ann