Subject Re: [IB-Architect] IB6 sequential scan improvement
Author Ann Harrison
At 03:24 PM 11/8/2000 +1030, Corey Wangler wrote:

> ibp_60_seq_scan_fs.html
>described the new feature of IB 6.0 where the cache
>management is improved such that large sequential scans
>do not clear out the cache.
>What I'm wondering here is if this feature could
>be altered to allow a setting for the number of
>page buffers that defines a "large" sequential
>scan? Maybe as a percentage of the available
>buffers (e.g. 25%)?
>Such a setting could be used to make it such that
>a given user cannot take over the entire cache
>when doing such operations.

I hope to hear from those who designed the feature,
but my inclination would be to make the limit something
like 50% up to 1000 pages, but I'd also like to see
some good tests that demonstrate the effect of the
behavior before we start hacking the code.