Subject Re: [firebird-support] Re: Firebird 2.5 SuperClassic on Linux 64 -OS memory allocation problem
Author Thomas Steinmaurer
>> You haven't mentioned which build you installed but 2048 *is* way too high for Classic/Superclassic 32-bit, even if you are running it on the 64-bit OS. Knock DefaultDbCachePages down to 75 pages and don't forget to erase the '#' character! Also remember that it won't kick in until everyone is off and someone reconnects.
>
> I don't understand this.
> A 75 page cache was always suggested for Classic as each connection has its own cache.
>
> Superclassic has a common page cache for all the connections.
> Superserver, which also has a common cache, can have a 10000+ page cache.
>
> Why should Superclassic, with a common page cache, be limited to 75 pages?

Nope. SuperClassic, like Classic, has a private page cache per
connection. Check out my architecture comparison sheet:
http://blog.upscene.com/thomas/index.php?entry=entry091016-133211


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!