Subject | Re: [firebird-support] Re: What's the difference between "Gbak -g" and "gFix -sweep" |
---|---|
Author | Ivan Prenosil |
Post date | 2008-05-05T18:35:28Z |
> Ok, so in conclusion doing everyweek (cause everydays i can't tooSweep does two things:
> long process that slow down the database)
>
> First
> fgix -sweep
>
> and immediatly after
> gbak (without -g)
>
> it's a good practice? everyone agree ?
- garbage collect whole database
- fix transactions states
I.e. immediately after doing sweep you do not need
to do garbage collection, so this is usual procedure:
fgix -sweep ...
gbak -g ...
(otoh, since garbage is already collected by sweep,
you will probably do not see any difference between
gbak with/without -g)
Ivan
http://www.volny.cz/iprenosil/interbase/