Subject | RE: [firebird-support] Software speed issue |
---|---|
Author | Leyne, Sean |
Post date | 2013-07-17T21:13:46Z |
> We are running Firebird 2.5.2 and the software we use that utilizes firebird isWhat OS/bitness are you running?
> 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 engine version (SuperClassic) are you running?
What are the database page cache settings?
How many active database connection are their?
<SL>