Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to have cursors never be sent to disk?
Message
From
20/01/2014 17:32:30
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01592171
Message ID:
01592198
Views:
73
>>>20 MB is nothing
>>>
>>>Depending on the value of sys(3050), cursors tend to stay in memory
>>>
>>>If written to disk, there's
>>>(1) the cache foxpro holds
>>>(2) windows' cache
>>>(3) Most likely, the write cache is turned on for the drive
>>
>>Not sure about #3, Windows boxes I've looked at have write cache disabled by default - rightfully so, as few client workstations have UPSs. If one has a UPS it can be enabled and does give a significant benefit.
>>
>>>And frankly, I do not see any need for a RAMDisk
>>
>>Agreed, 20MB is probably not even getting out of VFP's own buffers.
>
>I have been looking at a lot of windows 7 PCs lately and they all have the write cash turned on. I've been turning them off on server PCs as many of my customers run a small 2-5 peer to peer network. Sure your looking in the right place?

Device Manager...right-click on disk device or volume...Properties...Policies tab

I had to enable that on my Win7 Ultimate 64-bit box, it was disabled by default. I've left the secondary "Turn off Windows write-cache buffer flushing on the device" disabled.

The systems where you're seeing it enabled by default - are they OEM such as HP, Dell etc. ? If so I wonder if they're doing that so they get slightly better numbers in benchmarks.

Bottom line, write caching should be enabled only if the computer has a good UPS. On a network sharing VFP data files, it should probably be turned off on all computers ("server" + workstations) unless all computers have UPSs as well as the networking equipment (switch(es) etc.).
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform