> I would like some tips on how to speedup rbase when
> it running on a
> network.
If you can afford the maintenance effort, install and
run R:Base locally on each station, rather than from a
central copy on the network.
Make certain that scratch files are written to the
local C: drive, not to the network:
SET VAR vTempDir = (ENVVAL('TEMP'))
IF vTempDir IS NOT NULL THEN
SET SCRATCH &vTempDir
ENDIF
CLEAR VAR vTempDir
For any slow data retrieval check that you are not
missing an index that could help you.
For slow INSERTs and DELETEs, make sure you don't have
any indexes that you can do without.
For operations that use a subset of records and refer
to them repeatedly, consider moving them to a TEMP
table (which is local to your machine) before doing
the work, then moving them back when you're done.
If views or selects that draw from two tables or views
are very slow, see if you can use an OUTER JOIN in the
SELECT statement.
Check to see if you have any triggers or stored
procedures called when you select or update.
Look into the settings STATICDB and FASTFK to see if
they will help.
--
Larry
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
