> 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>