At 01:51 PM 7/9/2008, Dan wrote:
All indexes seem to be in place. I thought about dropping them and re-adding to see if that changes anything, but hoped that wasn't the answer. 40+ tables with multiple indexes. I watched carefully during the process. Saw no errors.
You may also want to revisit and make sure that SCRATCH settings are defined appropriately in RBENGINE8.CFG file. The SCRATCH setting allows the current R:BASE session to store all temporary sort files on the drive and directory based on the SCRATCH setting. Syntax: SET SCRATCH <value> Supported values: ON, OFF, TMP, or <fullpath> SET SCRATCH ON will store temporary sort files on the database drive and directory. SET SCRATCH OFF will store temporary files on the current drive and directory. SET SCRATCH TMP will store temporary files in Windows' User Environment TMP folder. SET SCRATCH <fullpath> will provide the path to the location where temporary files could be stored. By default, the R:BASE/OTERRO configuration files, such as RBEngine.CFG, RBEngine75.CFG, RBEngine76.CFG, RBEngine8.CFG, OTERRO.CFG, OTERRO35, OTERRO8.CFG, and RBASE76.CFG) include the keyword TMP for the SCRATCH setting. Using the typical installation option of R:BASE or OTERRO the appropriate configuration file is installed in the "Windows" folder. The default keyword (TMP) allows R:BASE or Oterro sessions to use the Windows' User Environment TMP Variable setting for SCRATCH files on startup. This will also eliminate all issues related to setting the SCRATCH directory and related files. This default setting also enables R:BASE/OTERRO to write scratch files without being concerned about read, write, and delete permissions on the network/local folders. To take advantage of this setting, use the option "SCRATCH TMP" in the appropriate R:BASE and OTERRO configuration files or use the "SET SCRATCH TMP" command in your application startup files. Did you know that you can use "SET SCRATCH TMP" command at the R> prompt or in your application startup file? Using the latest updates of R:BASE 7.6, C/S:I 7.6 and Turbo V-8 for Windows, you can. Previously, "TMP" option could only be used in the configuration (.CFG) files. You can also use the enhanced Settings | Configuration Settings option of the Database Explorer to define SCRATCH settings: R:BASE 7.6, C/S:I 7.6 and Turbo V-8 for Windows: Database Explorer | Settings | Configuration Settings... http://www.rbase.com/rbg76/ScratchSettings.jpg http://www.rbase.com/rbg8/ScratchSettings.jpg You may also take a look at following article available at: From The Edge: http://www.razzak.com/fte/ Topic: Gaining Speed with Programming in R:BASE Date: 12/07/2007 Hope that helps! Very Best R:egards, Razzak.
