>>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 Mike.

Alex