Subject Re: [firebird-support] Cache Performance Options
Author Joshua Hartmann
Post date 2014-05-13T14:31:20Z
Set,
There is a large gap because I turned off auto sweeping. I disabled it because when it was sweeping, it was killing performance even more. Previous to the 2.5.2 update, it was also using all the memory and causing the server to swap every time it did a sweep (20,000 transactions). Right now, I have it sweeping once during their lunch downtime and again at the end of the day. It is faster than before the 2.5.2 update, but still not fast.

-Josh


On Tue, May 13, 2014 at 12:18 AM, Svein Erling Tysvær svein.erling.tysvaer@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
 

>I am a MSP for a large dental office that uses an application with a Firebird DB. I've done a lot of database work in my life,
>but none with firebird so I need a little help with the configurations. The office is complaining of slowness and what we've
>done so far to help them will be below. Keep in mind, I am not the developer of the application, just a MSP trying to help
>them out since the developer has no clue what they're doing.
>
>We noticed the server would start pretty fast but then throughout the day slow down.
>
>Thanks for any advice you can give.

A slow database can have lots of reasons, Josh. I take it that the 'large dental office' is amongst the largest companies that use the application in question, either in terms of database size or number of simultaneous users? Your observation that things slow down gradually, indicates that one possibility is that the developer hasn't thought thoroughly enough about transactions (a vital part of Firebird). Try running gstat when the database is slow, maybe you will see a large gap between oldest and next transactions.

HTH,
Set