Thanks, I'm glad that I'm not alone in this. I will pass this on to my MCSE.
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only