>Nadya if you are using tables on an network then all the tempory tables will be on the network in this case you can have performance issuesin this case why don't you allways create a folder on the c drive an point to it on the config.fpw

Hi Alexandre,

Usually, we store our temp files on the local drives. For instance, I configured my VFP to use d:\TEMP, because my D drive is 20GB and C only 2GB. However, most of the users don't have big local drives, but they may need to run DataDict application, which changes tables structure for our huge tables. So, my manager suggested to create Work directory for this particular application on the Network drive, so it would be always enough space [Here, BTW, another problem, since this drive is 68MB and DISKSPACE() or George's workaround don't return correct space information, we discussed this problem couple of months ago]. I created config.fpw and placed it into my application directory, but it doesn't seem to make any effect...



>>>>Hi everybody,
>>>>
>>>>I need to understand, where Fox tries to create temp files during INDEX ON and ALTER TABLE commands on huge tables. I was thinking, it uses current place for temp files, but it seems, like it uses current location of databases instead.
>>>>
>>>>I'd like to check for available space before running ALTER TABLE / INDEX ON command, and I need to know, how many space I need and where.
>>>>
>>>>My second question is: can we re-direct temp files to the specific location for the specific application (this application is run under another main application). If yes, how?
>>>>
>>>>Thanks a lot in advance.
>>>
>>>It uses temp dir.
>>
>>Hi Cetin,
>>
>>I'm not sure. Let me explain, that happened. In my code I check Available space on current temp drive

pcTempDrive=justdrive(sys(2023)) && VFP Temp drive

When I ran my DataDict program, it gave a message, saying not enough free space to create g:\redp\dbc\ma\tranmstr.tmp (something like that), so I'm guessing, it also needs space on the drive, where tables located...
>>
>>My second question is: can I put path in config.fwp without drive letter, e.g.
>>\redp\Work\Temp?
>>
>>Thanks in advance.
>>
>>>For redirection use config.fpw :
>>>tmpfiles = path
>>>
>>>Also there are :
>>>sortwork = path
>>>editwork = path
>>>progwork = path
>>>
>>>options if you want to set them separately.
>>>Cetin