CompactDatabase and system cache (FILE_FLAG_RANDOM_ACCESS?)

[Yuri Zavorotny]

Hi,

I'm using JRO.JetEngine.CompactDatabase on a large (~1GB) .mdb file (Acess
2000 format). As it moves forward with compacting, the Windows system cache
grows slowly until there is no more free memory and then Windows starts to
swap out the memory allocated to applications. In other words, Windows goes
out of its way trying to put whole 1 GB file into the system cache,
resulting in heavy paging.

I know that Windows does that if a file is opened with
FILE_FLAG_RANDOM_ACCESS flag. Is there any way to alter this behaviour?

Any help will be appreciated!