Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to have cursors never be sent to disk?
Message
 
To
20/01/2014 16:59: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:
01592194
Views:
77
>>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?
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform