Subject | Re: [firebird-support] Re: Sweep question causing cpu spikes |
---|---|
Author | Douglas Tosi |
Post date | 2009-07-17T16:08:40Z |
On Fri, Jul 17, 2009 at 12:40 PM, javakqj<javakqj@...> wrote:
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
> But how would I explain the changes in the total versions for the table? WhoJust guessing here:
> is changing them ? Any thoughts.
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