Wait a minute, you forgot the line:
SET SCRATCH c:\temp
Or am I missing it in your code? You set the scratch OFF but never set it to
anything afterwards, so I imagine that would create memory issues!
Karen
On Thursday, March 6, 2025 at 02:50:10 PM CST, 'jim schmitt' via RBASE-L
<[email protected]> wrote:
Hi, Karen:
I updated my application start up file with the additional instructions
suggestions from doug,, bruce, and Karen. This startup file is the first thing
in my RBA application file. It seems to work, but the program blows up in
another area. with out of dynamic space or something like that The revised
startup code is listed below, and looks ok, but make something else blows
up.This is driving me crazy, and the administrator says this has to be working
tomorror.
Karen , Doug, Bruce....if any of you have any other suggestions or are
available to dial in and look at this, I would be most appreciative. Of
course, you will be renumerated.
Jim1-614-361-3942
-- MyApp.DAT Startup Application File-- Start Fresh
--- FROM 'FROM THE EDGE' --- 01-28-25
CLEAR ALL VARIABLESLABEL StartFresh DISCONNECT SET QUOTES=NULL SET
QUOTES=' SET DELIMIT=NULL SET DELIMIT=',' SET LINEEND=NULL SET
LINEEND='^' SET SEMI=NULL SET SEMI=';' SET PLUS=NULL SET PLUS='+' SET
SINGLE=NULL SET SINGLE='_' SET MANY=NULL SET MANY='%' SET IDQUOTES=NULL
SET IDQUOTES='`' SET CURRENCY '$' PREF 2 B DISCONNECT
--------------------- SET NULL -0- SET MULTI ON SET STATICDB ON
--- 02-20-25 SET ROWLOCKS ON SET FASTLOCK ON SET PAGELOCK OFF
SET MESSAGES OFF SET ERROR MESSAGES OFF SET ERROR MESSAGE 2495 OFF
SET SCRATCH OFF SET VAR VF_COUNT = (CHKFILE('C\TEMP')) IF VF_COUNT = 0
THEN MD C:\TEMP ENDIF
CONNECT UBILL ---dbname IDENTIFIED BY ownername SET ERROR MESSAGE 2495
ON SET MESSAGES ON SET ERROR MESSAGES ON -- Check the availability of
database IF SQLCODE = -7 THEN CLS PAUSE 2 USING 'Unable to Connect
the Database.' + CAPTION ' Your Application Caption Here ...' + ICON
WARNING + BUTTON 'Press any key to continue ...' + OPTION BACK_COLOR
WHITE + |MESSAGE_FONT_NAME Tahoma + |MESSAGE_FONT_COLOR RED +
|MESSAGE_FONT_SIZE 11 CLOSEWINDOW EXIT ENDIF-- Enforce Database
Default Settings SET QUOTES=' SET DELIMIT=',' SET LINEEND='^' SET
SEMI=';' SET PLUS='+' SET SINGLE='_' SET MANY='%' SET IDQUOTES='`'
SET CURRENCY '$' PREF 2 B SET NULL ' ' SET DATE FORMAT MM/DD/YYYY SET
DATE SEQUENCE MMDDYY SET DATE YEAR 30 SET DATE CENTURY 19 CLS -----EDIT
USING ApplicationMainMenu RETURN -- End here ...
On Thursday, March 6, 2025 at 09:42:31 AM EST, 'Karen Tellef' via RBASE-L
<[email protected]> wrote:
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.
--
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/363190427.1047004.1741294204685%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/740677241.893543.1741295155334%40mail.yahoo.com.
