Subject Re: [firebird-support] Re: firebird classic on windowx 2000|xp|2003
Author Thomas Steinmaurer
> thanks a lot for your feedback.
> On SuperServer, I usually set DefaultDbCachePages=20480 corresponding

2048?

What's the page buffers value at database-level?

> to 80 Mo ram. Application access to only one database. There is up to
> 100 concurrent connexions.

This would multiply your 80 MB (under the assumption that your databas
page size = 4K) by the factor of 100. ;-)

> The server has 4 Go RAM.
> Should I keep the same value on classic ?

No.

When switching from Super to Classic, a number one reason why you
*might* see worse performance with Classic is a too high page buffers
value in combination with quite a number of concurrent users eating all
your servers RAM.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com