Sorry late getting back to you.
1. Razzak just posted a spiffy generic Set Scratch file command on the lists:
>>>
The latest builds of R:BASE 7.1 for Windows (Build: 7.1.81.30720),
R:BASE 7.5 for Windows (Build: 7.5.11.30720), R:BASE V-8 "Turbo"
(Build: 8.0.9.30720) and Oterro 3.1, include the enhancement to
simply type "TMP" for SCRATCH option in RBEngine.CFG, RBEngine75.CFG,
RBEngine8.CFG and OTERRO.CFG files.
Updating the SCRATCH setting to TMP in the appropriate configuration
files, R:BASE/OTERRO will use the user's TMP environment settings
for SCRATCH files on startup.
Use any text editor or R:BASE Editor 7.5 to edit the configuration
file to read SCRATCH settings as follows:
SCRATCH TMP
>>>>>
2. I have almost all my code in File 4 using "Design Menu Bar" so I don't think the Files option has any bearing on my app. For that matter, I suspect that Buffers is N/A.
3. I have customers with a mix of RBG7RT.exe locations. I make a shortcut to the server if performance is OK. If too slow, like where I have remote wireless PC's, I get it off the local "C" drive.
Dennis
*****
At 11:39 PM 7/19/2005, you wrote:
Thanks Dennis for your input.
This is a command I have in my RBASE.DAT file.
SET VAR vtemp = (ENVVAL('TEMP'))
IF vtemp IS NOT NULL THEN
SET SCRATCH .vtemp
ELSE
SET SCRATCH OFF
ENDIF
Will that work?
I have Rtime installed on each local computer.
Should I try having it installed only on the server?
Are there any other settings I should know about
such as setting FILES, BUFFERS, or MAXTRANS?
Sharon Lima
Sharetech
753 Warren St
Westfield, NJ 07090
(908) 232-5286 (P)
(908) 349-3118 (F) - New
[EMAIL PROTECTED]
http://www.sharetech.net
- ----- Original Message -----
- From: Dennis Fleming
- To: RBG7-L Mailing List
- Sent: Tuesday, July 19, 2005 8:55 PM
- Subject: [RBG7-L] - Re: Network Optimization
- RBG7RT is much larger than Rtime65W so speed is a consideration.
- The EXE file is compress in later versions of RBG7RT but it is decompressed before it is sent over the network. I.e, on some networks you may decide to have RB7 on the local hard drive and on others it is fine to have it only on the server. Setting a local scratch file is important.
- You mention a 50MB file 2, but don't forget that all forms and reports in file 4 must also be pushed out to each PC, and also portions of the index (file 3) depending on which tables being accessed.
- Even a 50MB data base seems big on a slow network.
- Dennis
- ...
- At 01:43 PM 7/19/2005, you wrote:
- Hello All,
- It seems like I remember an article or discussion on this
- at some time in the past but cannot find the information
- now that I really need it.
- I am looking for a list of all settings and recommendations
- for speeding up performance over the network.
- My client is using a recent version of 7.1 runtime.
- The RB2 file in only 50 megs so I know things should
- not be this SLOW. Version 6.5++ was working well on
- the same network.
- Sharon Lima
- Sharetech
- 753 Warren St
- Westfield, NJ 07090
- (908) 232-5286 (P)
- (908) 349-3118 (F) - New
- [EMAIL PROTECTED]
- http://www.sharetech.net
- Dennis Fleming
- IISCO
- http://www.TheBestCMMS.com
- Phone: 570 775-7593
- Mobile: 570 351-5290
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290
