Subject Re: [firebird-support] Re: What's the difference between "Gbak -g" and "gFix -sweep"
Author Ivan Prenosil
> no, in normal use, you don't need to do a sweep if you run gbak without -g (that will
> collect the garbage)
> The only case you will eventualy need to run a sweep is if you have a lot of rollbacked
> transactions

Not exactly. Even single rollbacked transaction is enough to get performance problems
(starting of new transactions will get slower and slower).

However, rollbacked transactions are usually converted immediately to commited ones,
except some special cases (forced disconnection, too much updates in one transaction,
forbiding undo log in tpb etc.).
Sweep (or backup/restore) is also the only cure for limbo transactions.