Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
NT Server Reports Open Files following VFP Close Data
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00390169
Message ID:
00390323
Vues:
10
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform