--- 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/