Hi,

At Monday, July 20, 2009, 11:47 AM, Ryan Griggs wrote:

> A little preface: I'm working with a client that is running a POS
> application that connects to a Firebird 2.1 database. The problem is
> that Firebird is eating up all of the memory on the server and thus
> killing performance in a major way. The server is a quad-core with 16GB
> of memory running on Windows and is dedicated solely to this
> application. Firebird is currently set up in Classic mode and each
> spawned process is taking up around 250-300MB of memory. Typically
> during the day there are 50-70 concurrent connections via the POS
> application.

>

> My question is this: Do you think that there would be a notable
> performance increase by using Superserver mode rather than Classic?
> Also, are there any additional configuration options that I may have
> overlooked that might help with performance? I'm no Firebird expert but
> have worked with it in the past so I'm not entirely unfamiliar with it.

>

What's the page cache/buffers of the database(check it by using GSTAT
to retrieve the database headers)? It sounds like the page cache is
set at a high value, but with Classic I would recommend that it would
be set to 75 pages.


--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)