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 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))
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
Alexandre Palma
Senior Application Architect