I'll bear that in mind in future - it will certainly save a lot of
time.

Thanks for the tip.

--- In ib-support@y..., "stevelw02" <s.lee-woolf@s...> wrote:
> --- In ib-support@y..., "Wilson, Fred" <fred.wilson@b...> wrote:
> > Sounds like just a ton of garabage collection going on. Next
time,
> if you
> > plan on doing a restore also, run gbak with the No Garabage
> Collection flag.
> > No reason to do the garabge collection if you're going to turn
> around and
> > immediately restore the backup.
> That's exactly what I'm going to do. Given the large number of
> deletions I thought some tidying-up would be necessary for optimum
> performance.
>
> I obviously don't fully understand the garbage collection option -
> why is it not needed in these conditions?
>
> > We did some testing here a couple of years ago and found it much
> faster,
> > actually, to do a backup (no garbage collection) and then
restore,
> than to
> > do a sweep of a large database that had a lot of insertions and
> deletions
> > occur.
> >
> > Best,
> > Fred Wilson
> > SE, Bell & Howell
> > fred.wilson@b...
> >
> >
> >
> > -----Original Message-----
> > From: stevelw02 [mailto:s.lee-woolf@s...]
> > Sent: Thursday, May 09, 2002 8:21 AM
> > To: ib-support@y...
> > Subject: [ib-support] Re: Firebird Backups with Sweep
> >
> >
> > I actually initiated the command from within IBExpert. The only
> > option that was checked, as far as I can recall, was 'sweep'
> >
> > --- In ib-support@y..., "Nick Upson" <uebridger@h...> wrote:
> > > what gbak command line did you use?
> > >
> > >
> > > >From: "stevelw02" <s.lee-woolf@s...>
> > > >Reply-To: ib-support@y...
> > > >To: ib-support@y...
> > > >Subject: [ib-support] Firebird Backups with Sweep
> > > >Date: Thu, 09 May 2002 14:49:17 -0000
> > > >
> > > >I recently needed to prune a large table (7 Million records)
and
> > > >deleted approx 5 Million (they were fairly well distributed
> > > >throughout the table). Ti tidy everythiup, I initiated a
database
> > > >backup (via GBAK) with the intention of doing a subsequent
> restore.
> > > >
> > > >The original table, before deletions, took an average of 25
> minutes
> > > >to fully backup. The modified table has, so far, taken some 30
> > hours
> > > >and, extrapolating the current rate forward, looks like it
will
> > take
> > > >a further 14-16 hours to complete.
> > > >
> > > >Is this normal? It seems like a long time but I imagine that
> quite
> > a
> > > >bit of housekeeping is going on. Anyone got any thoughts?
Thanks
> > > >
> > >
> > >
> > >
_________________________________________________________________
> > > Join the world's largest e-mail service with MSN Hotmail.
> > > http://www.hotmail.com
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/