Subject Re: [firebird-support] Re: Sweep question causing cpu spikes
Author Douglas Tosi
On Fri, Jul 17, 2009 at 12:40 PM, javakqj<javakqj@...> wrote:
> But how would I explain the changes in the total versions for the table? Who
> is changing them ? Any thoughts.

Just guessing here:
Look at ENDTIME_IDX and notice how total dup and max dup change.
Apparently there are changes going on in this table.
Maybe a large update or delete/insert is going on and leaving garbage.
IIRC Classic collects garbage "cooperatively", which means that the
next statement that touches that table will have to collect garbage.

hth,
--
Douglas Tosi
www.sinatica.com