Subject Re: new Direct I/O for DataBase Files (interbase) - interesting
Author hvlad
<tomconlon7@...> wrote:
>
> Does anyone know if there are any plans for this in FB?

Sure.

> http://docs.embarcadero.com/products/interbase/IBXEUpdate2
>
> InterBase Direct I/O for DataBase Files
> The direct Input/Output (I/O) capability makes InterBase more scalable with very large databases on systems where there are memory resource limitations. With the Update 2 release, InterBase enables this "direct I/O" functionality on Windows OS. This functionality circumvents the issue observed by many on Windows 2008 R2 and Windows 7 64-bit OS editions where System File Cache uses up too much physical memory leading to sluggish system performance.

It is implemented few years ago in FB 2.1, read Release Notes :

http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-fbconf-fscache

Regards,
Vlad

PS The main question is if IB simple disable filesystem caching or
if IB now able to handle more advanced tasks itself : prefetch, for
example...