Re: RX2800 sporadic disk I/O slowdowns

Note:  Global buffers can be an advantage, but are not used when dealing
with duplicate secondary keys.  Those are handled in local buffers. I
have seen drastic differences in performance when changing bucket sizes
more with secondary keys that have many duplicates than with primary
keyed access.  Hein has some tools that analyze the statistics of
indexed files that report the number of I/Os per operation. High values
here can indicate inefficient use of buckets or buckets that are too
small forcing the use of more I/Os to retrieve buckets.  Increasing the
bucket size can significantly reduce I/Os resulting in better overall
stats.
This won't directly address the reported slowdown, but might be a
trigger for it depending upon data locality.
Dan