|Subject||RE: Database performance slowdown|
> We are investigating an issue with one of our systems where it graduallyYou should run gstat -h to check the transaction counter values. Please post the details here for review.
> slows down during the course of a day.
> We have our epos system that we write ourselves using Delphi XE2 and the
> IBX components.
> We have a group of tables that are updated during the end of sale save
> Typically this whole save process takes milliseconds, but on one particular site
> we see it taking several seconds and occasionally taking up to 35 seconds.
> We have done some digging into the behaviour of Firebird, we are currentlyThis would be a sign that there is a db connection that is not committing transactions as it should.
> using v2.5, and it appears that Firebird needs to check the entire chain of
> back versions when reading a record from the database. Is this the
> cooperative Garbage Collection process running?
> It seems like it would be logical for a lookup to only search back records until
> it finds the record that is supposed to be visible to it, but it appears to go all
> the way back.