Hi Alejandro,
we've been telling our users who want to use VM's that the must provide a ramdisk for tmpfiles (which we set in the config file, of course). The reason is that a) we do a lot of queries; and b) VMFS, even in VSphere 5, is slow at big block writes (v5 speeds up small bursts, but doesn't affect the big block writes). We set up 4GB for up to 20 users. For a single user, 500MB seems to be plenty. We do, by default, on app launch delete all tmpfiles files that are not currently locked. A tmpfile not currently in use has no need to exist. :)
Here are the directions we give them (minus the Google Site formatting, which didn't paste into the message):
Setting Up A Ram Disk
Using this link
http://forums.guru3d.com/showthread.php?t=356046 use NFTS as the file system type, and use the task scheduler On Startup as the creation method. The reason for this is that a ram disk goes away when the computer shuts down/restarts.
Note: on a customer site, it is up to their IT to set this up. Feel free to copy this information to them, leaving out the NAS information.
IMDisk can be downloaded from here:
http://www.ltr-data.se/opencode.html/#ImDiskhth,
Hank
>I've noticed files get created in temporary directory when VFP executes a SELECT INTO CURSOR xx.
>
>Is there a way to keep cursors 100% in memory and never go to disk, even READWRITE cursors? Sort of like the Ramdisk in DOS days.
>
>TIA,
>
>Alex