Subject | Re: [firebird-support] Large database performance on Firebird 1.5.2 CS with 130+ clien |
---|---|
Author | Thomas Steinmaurer |
Post date | 2005-03-24T15:35:54Z |
Hi,
[snip]
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
[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