--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> > > 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 actually thought about.
My problem right now, is that I doesn't want to cause any more
problems until after Christmas. The customer is angry enough as is ;-)

But I'll think I'll give it a try ....

The sweep function - Does it take a lot of power away from the DB ?
And uses a lot of memory ?

Michael

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