Subject Re: [IB-Architect] SUPERSERVER_V2
Author Dmitry Kuzmenko
Hello, Ann!

Ann Harrison wrote:

> > FILE_FLAG_OVERLAPPED |
> > FILE_FLAG_NO_BUFFERING |

> One of the characteristics of the development of InterBase
> at Borland is that some directions were explored and abandoned,
> leaving the code in place, but conditionalized out. SUPERSERVER_V2
> was such an effort. The one consistent factor among these features
> is that they never made it into the QA system. Some are more complete
> than others. Expression indexes and scrollable cursors are two more
> such features.

I can't believe that eliminating unneccesary OS buffering will
decrease performance. It is simple to look into TaskManager when
select count(*) is made on a big table:
While IB is reading pages into it's cache, they are also being read
(before IB) into OS File Cache. So, availavle memory decreases, which
can reduce OS performance (and IB's too). Isn't it?

--
Dmitry Kuzmenko, Epsylon Technologies.