>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
