thanks a lot!

last question, what is better

gfix -sweep ...
gbak ...

or

gbak ...
gfix -sweep ...

because actually i do the second one and i notice that the GBAK is very slooow (more than 12 hours to backup a database, and this everydays) ?

thanks by advance
stephane

--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> svanderclock wrote:
> > so if i understand well their is no advantage to do :
> >
> > gfix -sweep ...
> > following by
> > gbak ...
> >
> > it's better for the exactly same result to do
> >
> > gfix -sweep
> > following by
> > gbak -g (g = not do garbage)
> >
> > right ?
>
> There's a small advantage to garbage collecting with gbak,
> even if you just did a sweep. The sweep removes only those
> record versions that were obsolete when it started. Gbak
> will get anything that began to smell between the start of
> the sweep and the start of the backup. And since you've
> already got all the nasty old garbage with the sweep, there's
> not much left to slow down gbak.
>
>
> Cheers,
>
> Ann
>