Some in this group have looked at this in the past but we are still not exactly sure why...

The thread is #364019 but it's not exactly what you are talking about.

Here is what I know.

NT keeps a files that have been opened and closed. IN some sort of a file cache for I suppose better performance.
In the foxpro case it always seems to leave the FPT file open.
There is some code I have used to varify this in the file section. It's in the file section called: OpenFiles or something.

I think it occurs more under NTFS but I can't verify this Yet.

It's the shows the same thing you are noticing.

From my Oracle DBA experience I know the following more things you could try:

1) Add / Change these registry entries

Its pretty obvious what these do from their descriptions. Performance gain is rumoured to be up to 5% but
I haven't tested to fully prove this assertion, and of course does not change in any way my view that every
Oracle database should use raw devices.


[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem]
"NtfsDisableLastAccessUpdate"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem]
"NtfsDisable8dot3NameCreation"=dword:00000001

2) Change the preference: In the control panel. Network -> Services, choose the server service and click on the
properties button.
You'll see a radio button that makes NT work as an application server or a file server.

It does something strange when you have it set as a File Server which is what you might expect to
set it to for a foxpro application but I thought about trying to set it as an Application Server.

I am not having the problem at the moment in a consistant enough way so I haven't tested my theory.

But I can't see any harm in trying it?

3) Use raw devices or FAT rather than NTFS.... Not sure if this will work but ....Just another idea..

I have a guess these might work but can't prove it.

Let me know if this helps.