>>>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