Subject Re: [firebird-support] Garbage Collection Question (WAS: Re: Slow SELECT/DELETE)
Author Kurt Federspiel
Thanks again, Adam.

After reading the articles, everything is pretty
clear; we likely need very little garbage collection.
I would bet that the OI and OA are within a few of
each other at all times.

I am not sure what you mean by 'shape' of the data.
Can you clarify a bit??

Thanks again.

>--- Adam <s3057043@...> wrote:
> --- "federonline" wrote:
> >

------------ SNIP ------------

> > 2) can you tell me the affect of the constant
> > purging of data on the index??
> Probably not as serious as you worry, providing the
> 'shape' of the data doesn't change too drastically
> causing the statistics to be unreliable.

------------ SNIP ------------

Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.