Subject Re: [firebird-support] Large database performance on Firebird 1.5.2 CS with 130+ clien
Author Thomas Steinmaurer
Hi,

[snip]

> any suggest ?

What's the page size of the database and what is the value for page
buffers? Run gstat -h to get these values.

Possibly it is a database previously used under SuperServer, now using
Classic, and due to a somewhat high page buffers value (in combination
with 130+ connections), the cachable memory exceeds the maximum
available memory?

Just a thought.



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