Subject RE: [IB-Architect] order by not using index
Author Leyne, Sean
Alexander,

This notion of "read ahead" is what Charlie was working on with his
SuperServer 2 coding. From the code that I've read,the idea of
SuperServer2 was to 'detect' when a natural scan was occuring and then
use this 'state' to control the operation of the page cache (not to
overload the cache with pages from the natural scan) and to perform some
read-ahead disk operations.

Unfortunately, the code is not currently active and the exact state is
not really known. Maybe we can indulge Charlie to give us his comments.

This code will also be reviewed by the Firebird project following the
v1.0 release. I suspect that this is also being reviewed as part of
Borland's IB 6.5 plans.


Sean