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 16:59:30
 
 
To
20/01/2014 12:57:09
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:
01592193
Views:
74
>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.
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
Next
Reply
Map
View

Click here to load this message in the networking platform