Subject RE: [firebird-support] Software speed issue
Author Leyne, Sean
> 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?