Subject | AW: [ib-support] Re: Problems with gbak |
---|---|
Author | Henner Kollmann |
Post date | 2002-03-22T08:09:18Z |
>Some time? Are 10 hours enough time? Tested it overnight and after 10
> I'd guess that it does not really hang, it is just very busy
> doing the
> garbage collection (GC). GC on 2.500.000 may take some time,
> and if there
> are indexes it will be even slower.
hours the engine is busy....
> Drop (or set inactive) indexes before doing the delete. YouIs an idea, will test it.
> can GC by
> doing a "select count(*) from XXX", optionally with a "where"
> covering just
> the records that were deleted.
Regards,
Henner