>>>>Even smarter would be a way to change temp path for any new item while keeping the list of currently open temp files on previously set paths via SET command. Had issued such a enhancement wish, MS reaction was along the lines of "interesting idea, makes technical sense, but we won't go for it - usual user does not face such problems..."
>>
>>Looks like he just did that too, using a new SYS(9021) function:
>>
>>
SYS(9021,"TMPFILES","%TEMP%\%VFPPROCESSID%")
>>
>>
>
>I wish we had this 20 years ago...
Yupp...
Back in the days of 2 IDE drives on PIO, 2 SCSI controllers with tape drive, scanner and 7 SCSI drives ranging from 0.5 to 2GB each I wrote a class for a round-robin schema for "temp tables" with automatic cleanup - having cursors settle on different physical discs would have eliminated most of that code ;-)