1. Windows 2008 R2 Enterprise 64bit

2. Not sure on the version all they said was 2.5.2 when they upgraded
us.

3. FileSystemCacheSize = 70. They put this in at the very end of the
conf file with NO # signs around it. Every other line in the conf file
starts with #.

Example:

# Number of cached database pages

# This sets the number of pages from any one database that can be held

# in cache at once. If you increase this value, the engine will

# allocate more pages to the cache for every database. By default, the

# SuperServer allocates 2048 pages for each database and the classic

# allocates 75 pages per client connection per database.

#

# Type: integer

#

#DefaultDbCachePages = 2048

4. 31 users connected





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Wednesday, July 17, 2013 5:14 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Software speed issue

> We are running Firebird 2.5.2 and the software we use that utilizes

firebird is

> very slow in some areas such as compiling reports. Do to caching and

speed,

> they suggested that we increase the page size and percent of RAM that can
> be used. We did this and saw little to no increase in speed. Our database

is

> 120 GIG and we have 96 gig of RAM available which we are only using 5 gig

of

> that 96 gig. Can anyone suggest settings that can be changed/activated

(they

> originally had all of the commands in the firebird.config file commented

out

> so they were not active) and what values we can try to increase the speed?
> We want their software to be much faster than it is and they have no other
> ideas. Thank you

What OS/bitness are you running?

What engine version (SuperClassic) are you running?

What are the database page cache settings?

How many active database connection are their?

<SL>





[Non-text portions of this message have been removed]