Thomas Steinmaurer skriver:

>> I also read through
>> http://www.firebirdsql.org/manual/gfix-housekeeping.html once again. It
>> seems to say that GC only happens on a full table scan, e.g. select
>> count(*). I thought GC happens on a page by page basis, as each
>> individual page is accessed.
>
> I even think it works on a per-record basis removing old record
> versions, which aren't used/needed by other transactions anymore.
>
>> Can access to only small portions of a large table trigger GC on the
>> entire table?
>
> I'm not sure, but I would say no.
>
> I would try the trace route to see exactly what's going on in the
> database statement wise.

Yes, I will probably do that as soon as possible.

> Btw, any suspicious things in the monitoring tables at the time things
> get hooked up?

I'm not very familiar with them. Any ideas what I should be looking for?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64