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


>--- 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.
http://answers.yahoo.com/dir/?link=list&sid=396545469