Temporary files are created during R:BASE processing. The temporary files use the .$$$ file extension. Where they are stored can affect processing speed. In multi-user environments, it is very important that each user's temporary files be stored locally. The SCRATCH setting controls the directory location for the temporary files.
Syntax: SET SCRATCH <parameter>
Default: TMP
Parameter |
Description |
TMP |
stores temporary files in the Windows TEMP directory |
ON |
stores temporary files in the database directory |
OFF |
stores temporary files in the current directory |
<path> |
stores temporary files in a specified directory |
With SCRATCH set to ON, temporary files are stored on the database directory. This means slower operation in the typical multi-user environment because the database resides at the server, requiring the temporary files to be frequently transmitted over the network. For faster database speed, set SCRATCH to TMP. The TMP value directs R:BASE to store the temporary files on the current user's local "TEMP" directory, regardless of their operating system. This will help eliminate all issues related to the access rights, disk space, etc., when running R:BASE on enterprise servers. However, TMP requires your local workstation to have a hard disk with enough space to store the temporary files.
To set SCRATCH to TMP, use the following:
SET SCRATCH TMP
The SCRATCH command can be set in the configuration file so that the setting is made prior to launching R:BASE. Use the R:BASE Editor or any text editor to edit the configuration file to read the SCRATCH settings as follows:
SCRATCH TMP
