Yes, i understand

I do backup every week, and i want to know if after the backup (done
WITHOUT the -g) i must launch the gfix -sweep ?

Some firebird tech say that i must ... but i far as i understand i
don't need...

in other word :
What exactly gbak (without -g) do (except the backup) and what exactly
gfix -sweep do ?

thanks by advance
stephane



--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> svanderclock wrote:
> >
> > I want to ask if :
> >
> > Gbak (without -g)
> > and
> > "gFix -sweep
> >
> > ABSOLUTELY IDENTICAL ?
> >
>
> No. First, gbak creates a backup file. You could direct that
> to the null device, but it's still going to go over all data,
> metadata, and procedural objects and try to make a copy of them
> that can be restored. Second, gfix -sweep resets the value of
> the "oldest interesting transaction". That reduces the cost
> of some internal bookkeeping.
>
> If you want both effects, setting the oldest interesting
> transaction to the oldest transaction that was running when
> the sweep started and creating a backup file, you could run
> the sweep first then a gbak with -g since there will be
> little or nothing to garbage collect.
>
> Regards,
>
>
> Ann
>