Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement