Hi Jim I'm going to jump in here for a moment. Sorry for interrupting the conversation on what can be done on the R:Base side. Years ago I worked a lot in 2.11 to 4.5, but no large experience with the current versions. Instead, I'm going to let the engineer side out. If your using three PC's with one acting as a server, that generally doesn't work well if there is a lot of work on the server PC to do. In any case, I would do the following to try and eliminate the hardware as an issue. The things that come to mind that I would look at first are, Memory, Virtual Memory and Hard Drive - on the Server PC. So from this point, I'm only going to refer to the "server pc". 1 If that PC has an old spinning hard drive, you would be better off with a SSD. 2 If there isn't enough memory for everything on that PC, your going to have issues, especially if you having to use Virtual Memory - large or small allocation. Here is what I would do to start. Start up the server PC, bring up Task Manager. At this point, I would only be interested in the CPU/MEMORY/DISK/NETWORK stats at the top - not concerned with the processes at this point. See what the numbers seem to stay at. Start you app, on the server PC, and again, get the numbers. Start PC 2, get into the app...not just starting but someone running the app on both the server and PC 2. What are those numbers now? Then move to machine 3. Now also get someone running the app on #3, and again go back to the server pc, and see what those numbers at the top are showing. My guess is that if it's hardware related, you will probably see the disk pegging a 100% from time to time. You could also in task manager go from Processes to Performance and look at the disk and memory in detail and see what it's showing in the Virtual (paged) memory. If the disk is swapping to Virtual memory, that isn't good either.
And one more note, some Virus Protection software isn't real friendly with it's scans. There are ways to look for that, but the easiest test is to disable it on the server pc for a few minutes and see what happens. Just be sure to turn it back on when your done testing. Hope this maybe helps and point to or eliminates hardware issues. If you find something, feel free to respond back. From: "'jim schmitt' via RBASE-L" <[email protected]> To: "'Karen Tellef' via RBASE-L" <[email protected]> Sent: Thursday, March 6, 2025 3:50:04 PM Subject: Re: [RBASE-L] - Slow computer on network 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. Jim 1-614-361-3942 -- MyApp.DAT Startup Application File -- Start Fresh --- FROM 'FROM THE EDGE' --- 01-28-25 CLEAR ALL VARIABLES LABEL 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 OFF SET VAR vCount = (CHKFILE('c:\temp')) IF vCount = 0 THEN MD c:\temp ENDIF SET 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, Bruce Thank 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 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" < [ mailto:[email protected] | >[email protected] ] > To "rbase group" < [ mailto:[email protected] | [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 | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/1132676101.694378.1741228875134%40mail.yahoo.com?utm_medium=email&utm_source=footer | 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 | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/em6de80295-7ccb-439a-90ab-2cce947f6c84%40685cf91f.com?utm_medium=email&utm_source=footer | 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 | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/562231479.780682.1741253584269%40mail.yahoo.com?utm_medium=email&utm_source=footer | 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 | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/156335286.729276.1741272141584%40mail.yahoo.com?utm_medium=email&utm_source=footer | 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 | 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 [ mailto:[email protected] | [email protected] ] . To view this discussion visit [ https://groups.google.com/d/msgid/rbase-l/363190427.1047004.1741294204685%40mail.yahoo.com?utm_medium=email&utm_source=footer | 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/2125004295.34919916.1741296188469.JavaMail.zimbra%40gwenetworks.com.
