Subject | Re: [ib-support] A few sweep questions |
---|---|
Author | Jason Chapman (JAC2) |
Post date | 2003-04-09T07:46:09Z |
All AFAIK:
""Michael Vilhelmsen"" <Michael.Vilhelmsen@...> wrote in message
news:b70djq+7cd9@......
then this gap between OT and OA will grow and not reduce until you do a
sweep.
JAC
""Michael Vilhelmsen"" <Michael.Vilhelmsen@...> wrote in message
news:b70djq+7cd9@......
> HiNo, it will perform garbage collection on every row though.
>
> First:
> If running a GBak -Backup ..... of a DB will that resolve in a sweep
> being performed ?
> Second:Yep.
> We have build 3 application that all connects to 1 DB.
> At all our customers sites, we can see, that in the morning, before
> anyone logs in to the DB the transactions are with 1 between them.
> I.e.
> OT 8419, OA 8420, OS 8420 and NT 8421.
> Then during the day this gab grows and shrinks while the users areCongratulations.
> using the system.
> But as the last user logs out, the gab shrinks back to 1.
> This is normal behavoiur, if every transaction in our programs areI'm pretty sure that if you rollback a transaction that has changed data
> either commited or rollback, correct ?
then this gap between OT and OA will grow and not reduce until you do a
sweep.
> Third:See my answer above.
> If I disable the automatic sweep function, and the above senario is in
> place, would I then (teoretically) need to do a sweep ever ?
JAC