Subject | Re: [firebird-support] Garbage Collection Question (WAS: Re: Slow SELECT/DELETE) |
---|---|
Author | Kurt Federspiel |
Post date | 2007-06-06T17:15:14Z |
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.
____________________________________________________________________________________
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
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:------------ SNIP ------------
>
> --- "federonline" wrote:
> >
> > 2) can you tell me the affect of the constant------------ SNIP ------------
> > 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.
>
____________________________________________________________________________________
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