Subject AW: [ib-support] Re: Problems with gbak
Author Henner Kollmann
>
> 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.

Some time? Are 10 hours enough time? Tested it overnight and after 10
hours the engine is busy....




> Drop (or set inactive) indexes before doing the delete. You
> can GC by
> doing a "select count(*) from XXX", optionally with a "where"
> covering just
> the records that were deleted.

Is an idea, will test it.

Regards,
Henner