Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
>Hi Craig and Martina,
>
>Just ran a test with and without RamDisk for tmpfiles and sortwork and was disappointed.
>
>I am trying to optimize ExcelListener where there is a ~20MB cursor on which I run many SELECTS. Guess I have defined enough indices so that Rushmore is able to do its job well.
If you put the original file into the ramdisk it might perform faster. If you run a query that produces a cursor - usually with READWRITE, and store that in the RAM disk and subsequently requery the cursor, it will not perform well until you add indexes to the cursor. If you have a big enough ram disk to hold the file and it is indexed, you might see some improvement.
>
>Thanks for the answer.
>
>Alex
>
>
>
>>- Ramdisk for Windows...
>>- move TMP folder to RamDisk volume
>>
>>MartinaJ
>>
>>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only