At 12:53 PM 2/1/2001 +0300, Dmitry Kuzmenko wrote:

>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?

Running out of memory isn't usually a problem on modern machines.
Avoiding reading the same page twice is often a help and if the
page stays in the OS cache after the IB cache throws it out, that's
a win, of sorts.


Regards,

Ann
www.ibphoenix.com
We have answers.