Tom,

> Does anyone know if there are any plans for this in FB?
>
> http://docs.embarcadero.com/products/interbase/IBXEUpdate2

{FYI, the link only works for IB users/licensees}

I don't think that any FB change is required. There is a much better solution which is already available from Microsoft to directly address this issue:

Microsoft Windows Dynamic Cache Service
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e24ade0a-5efe-43c8-b9c3-5d0ecb2f39af&displaylang=en

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

I like the ability to use the Windows cache for database data, we have systems that have multiple databases running on Classic, so having Windows maintain a tier-2 cache for database pages is a very good thing.

In that way, the actual database usage/activity will determine what is maintained in memory vs. having to pre-allocate a large block of memory for the FB/IB page cache.

The IB feature completely eliminates that option, which is too "black and white" for me.


Sean