|Subject||Re: [firebird-support] Re: What's the difference between "Gbak -g" and "gFix -sweep"|
> no, in normal use, you don't need to do a sweep if you run gbak without -g (that willNot exactly. Even single rollbacked transaction is enough to get performance problems
> collect the garbage)
> The only case you will eventualy need to run a sweep is if you have a lot of rollbacked
(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.