Subject | Re: [firebird-support] Re: Firebird Restarting part 2 |
---|---|
Author | Lucas Franzen |
Post date | 2006-12-28T14:08:13Z |
Michael,
Good.
Try to find out which transaction(s) is (are) running that long without
being committed and try to change this.
Don't use SavePoints or CommitRetaining if there's a chance to use commit.
I would prefer this one over disconnecting and reconnecting to the db ...
Luc.
> So all in all (based on 1 day of observation ;-) ) I think the sweepSeems that you found the problem.
> did take a lot of res. and memory.
Good.
> Another thing I tried (on a diff. DB, a smaller customer) was forcingYes.
> a disconnect from the DB and a connect to the DB every once in a while.
> This customer now has a gab between 50 and 400. Usually it was
> somewhere between 500 and 6000.
>
> I think I'll try that on this big customer DB as well.
>
> Anywas with any comments on this ?
Try to find out which transaction(s) is (are) running that long without
being committed and try to change this.
Don't use SavePoints or CommitRetaining if there's a chance to use commit.
I would prefer this one over disconnecting and reconnecting to the db ...
Luc.