Subject Re: [firebird-support] Re: How to find out buffer size.
Author Ivan Prenosil
>> In the case of Superserver, this
>> could be higher or lower than the Db header (default cache size)
>> figure, since the cache is shared by all connections and cache size
>> in SS is dynamic and not limited to the default.
>
> so that means there is no way to limit the amount of memory thats
> used. Is that so?

* There is some default cache size built in into fb server.

* This default can be overriden by setting in firebird.conf

* The actual size can be further modified by request during connect.
For Classic, it can be higher or lower than default.
For Superserver, the current value can be only increased.

* The cache size can (*should*) also be determined by the value stored in db header.
This value has the highest priority - it can't be changed by connect or by firebird.conf

Ivan
http://www.volny.cz/iprenosil/interbase/