Subject RE: [firebird-support] Re: Firebird Restarting part 2
Author Alan McDonald
> > 25,000 between the oldest active and the next.
> > approx 76,000 transactions per day based on total numbers since June 14
> >
> > it's a large gap but at that rate of transactions, it doesn't look too
> > silly - about 8 hours behind.
> > really round numbers here, but at your user level (maybe average 75)
> that's
> > about 1000 transaction per user per day (about 2 trans per minute).
> There's
> > no way of telling if one user is keeping it back 25 days behind the
> rest or
> > all users are keeping it 8 hours behind the leader.
> > It would be interesting to see if this gap closes during quieter
> times and
> > widens again during busy times or if it remains that wide all the time.
> > Maybe my logic is warped....
> Hm - When everybody disconnects at nigth, the gab closes down to
> somewhere between 2 and 1000.
> This happens every evening.
> I know this, because this was a major concern at a certain point in time.
> So almost 2 years ago I optimized my programs, and made sure that
> every transaction I start gets committed.
> Bur during the day the gab usually get bigger and bigger until they
> start to disconnect.

even though you have put a lot of work into ensuring that your transactions
commit, I still wonder if this gap is causing a sweep. Have you tried
setting sweep to 0 which stops it auto firing, and do a manual sweep and
garbage collection at night?

> I have seen it as big as 100K.
> But usually it around 20 - 40 K at all time.
> Michael
> > Alan