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 setScratch
ELSE
MKDIR 'C:\XX\RBTEMP'
ENDIF
LABEL setScratch
SET 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. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond 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 PM
Subject [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.
Jim
1-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
<https://groups.google.com/d/msgid/rbase-l/1132676101.694378.1741228875134%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
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.
