Subject RE: [firebird-support] Re: Firebird Restarting part 2
Author Alan McDonald
> Yesterday was the first day with all users connected and the sweep
> disabled.
> The GAB became as large as 200K, but noone noticed.
> When everybody disconnected at nigth it shrank down to 1.
> The sweep ran in the middle of the nigth and took 25 minutes.
> The memory use was significantly smaller at the time where it has
> prev. been a problem.
> So all in all (based on 1 day of observation ;-) ) I think the sweep
> did take a lot of res. and memory.
> Another thing I tried (on a diff. DB, a smaller customer) was forcing
> 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 ?
> Michael

forcing the disconnect..? how? shutdown? or asking them to close?
still sounds like a long running transaction to me. Maybe something you have
had all the time and still haven't found it in your code.