""Henner Kollmann"" <Henner.Kollmann@...> wrote in message
news:000e01c1d178$deacc5b0$1e5562c1@......

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

Garbage collection happens in a low priority thread. Depending on the
system's activity, it may take long time. This is not to say that I consider
10 hours acceptable. You could try to attach with gfix and demand an
immediate garbage collection (-sweep).

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing