IMO, scratch directories should be local, not on the server. Quicker to put
scratch files on the workstation, rather than sending all that temporary data
over the network.
Like what Bruce suggested, I have this in all my startup files.
SET SCRATCH OFFSET VAR vCount = (CHKFILE('c:\temp'))IF vCount = 0 THEN MD
c:\tempENDIFSET SCRATCH c:\temp
As another note, I never worry about config files anymore. One of the huge
benefits when one of the versions came out (9, I think?) is that you can ignore
configuration files as long as all the necessary settings are put in your
startup. I literally could not tell you where ANY of my clients have their
configuration files. I have no clue, are they local or on the server? I have
no idea and it doesn't seem to affect anything.
Karen
On Thursday, March 6, 2025 at 03:33:10 AM CST, 'jim schmitt' via RBASE-L
<[email protected]> wrote:
Hi, BruceThank you for the suggestion.I hope I am asking / explaining this
coherently.Here is some additional info.The application is running on a server
and the three user computers are connected to the server.
The icon on each user computer looks like: Target:
C:\RBTI\RBG11\RBG11.exe "UBILLGO.RBA" Start in G:\UBILL
My DBSTARTUP.RMD is not currently in the UBILLGO.RBA file, which drives the
application, but i will insert it today as it will be the first command at
startup..
I though (and I may be wrong), when a user connects to the server, it reads the
config file on the server (G)
Concerning scratch or temp files:I haven't set up any scratch or temp files on
the workstations or the server.Should i go to the server and make a directory
called 'TEMP', and then in the DBSTARTUP file add SET SCRATCH TEMP .If so,
should the instruction be SET SCRATCH TEMP or SET SCRATCH 'TEMP'.Thank you for
your assistance and suggestions.Losing sleep over this client.
On Thursday, March 6, 2025 at 12:25:28 AM EST, Bruce Chitiea
<[email protected]> wrote:
Jim:
The step-wise slowdown as each machine connects suggests that your client is
attempting to host the database on one of the three workstations. The database
engine is basically idling; but the operating system and Ethernet portal on the
host workstation are hard-pressed to manage overlapping input/output streams
from all three stations at the same time. Depending on the setup, it is
altogether possible that each user's temporary files are being streamed from
the host machine ... a REAL performance killer.
One way to check that theory is to ensure that each user's temp files are
created on that user's local machine. You can do this by creating a "scratch"
folder on each machine, and placing the following in each user's startup file
above the CONNECT UBILL statement.
-----------------scratchfile location --IF (CHKFILE('C:\XX\RBTEMP')) = 1 THEN
GOTO setScratchELSE MKDIR 'C:\XX\RBTEMP'ENDIF
LABEL setScratchSET SCRATCH 'C:\XX\RBTEMP'
This setup presumes a local "C:" drive (I prefer a separate local "D:" drive
dedicated to data); an "\XX" folder dedicated to hold temp files from all
programs; and an "RBTEMP" folder reserved for the local R:BASE temp files. But
the path can be whatever makes sense in your environment. Search the online
RBSYNTAX resource for SET SCRATCH for more info.
The R:BASE MultiUserGuide.pdf, found in your RBTI\RGBxx folder will help you
get up to speed.
Hope that is helpful, Bruce
Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA
91765-2203
[email protected] (909) 238-9012 m
------ Original Message ------From "'jim schmitt' via RBASE-L"
<[email protected]>To "rbase group" <[email protected]>Date
3/5/2025 6:41:14 PMSubject [RBASE-L] - Slow computer on network
Good Evening:
I have several clients , almost all of which are single users (not networked).
Now, with a new client with 3 computer connected to a network, I may be in over
my head. So, I am asking network people for suggestions.
, Operator 1 logs in and program runs fast, operator 2 longs in, and things
slow down, operator 3 logs in and this slow to a crawl. If fact, when they try
to enter a 9 digit account number, the digits entered display exceeding slow.
I've never used a 'start up' file, but after reading one of Razzak's 'From the
Edge' articles, I believe with a network, I need a start up file.
I've never used 'set STATICDB ON' OR 'SET ROWLOCKS ON' AS i haven't done any
networking.
So, I now have a start up file, and my questions are.Is this what I need (code
included), and will adding a start up file speed things up ? Do i need to do
more ? Other things ? Running out of time.Thanks in advance for any suggestions.
Jim1-614-361-3942
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1132676101.694378.1741228875134%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/em6de80295-7ccb-439a-90ab-2cce947f6c84%40685cf91f.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/562231479.780682.1741253584269%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/156335286.729276.1741272141584%40mail.yahoo.com.
