I have tried running rbase locally and regular rbase also not runtime. No difference in speed. However I will try to upgrade to 1gig NIC's and 1gig switch. They are not too expensive these days, and I will see what happens. Thank you for your help. Mark
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Tuesday, September 14, 2004 1:24 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: slow computer Mark, It would be more maintenance work for you, but have you considered running RBase locally with only the db on the server? I'm not using runtime so I don't know if there are any performance issues there. I'm not too proficient on the hardware side of things, but maybe you could watch the performance while RBase is being accessed to see what is hogging resources either on the server or on the workstation. Performance was sometimes better for me in the morning and I assumed (wrongly) that it was because not all users were logged in. I now believe it was because there was less telephone activity. Using ENTER USING was slower in the past but now works as fast as EDIT USING but you still might want to do a comparison. Doing UPDATES with where clauses inside of forms slows things down for me (maybe I need better indexes!) It's detective work trying to figure this out. Good luck! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Kwoka Sent: Tuesday, September 14, 2004 11:59 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: slow computer All cabling is CAT5, the switch is dedicated to data only. All workstations run windows XP, most have 256mb RAM but only a couple of them are over 2 GHz but these are slow too. I will try your suggestion with rbase.dat startup file. I also should mention that I use other applications on the network like MAS90 accounting and it is not slow at all. Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Tuesday, September 14, 2004 12:32 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: slow computer Mark, If I recall properly, the first step is to make sure that temporary files are written to the local desktop as opposed to the server. Put the following in your startup file (rbase.dat): SET VAR vtmp = (ENVVAL('TEMP')) SET SCRATCH .vtmp The new Cisco switch and NICs are all good moves but is the cabling CAT5? Is the switch dedicated to data? What is the RAM and the page size for virtual memory setting on the workstations? Are all computers (server and workstations) running Windows? TCP/IP only enabled? After struggling with this problem for almost a year, I now have the fastest RBase in the west (well, at least in Texas <g>). I upgraded to 2.6 GHz, 512 MB RAM, 1 Gig NICs, 1 Gig data dedicated switch. At the root of my problem was a shared data/voice switch and plugging computers into the deskphone with a 10 mbps limit... Many people on this list have a lot more experience than I do and will probably have more suggestions for you but that should get you started <g> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Kwoka Sent: Tuesday, September 14, 2004 10:49 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: slow computer I have a very similar problem with my network. I am running R-Base runtime ver. 77 latest update. Database files and rbase files are on the server. Each workstation (about 15 users) starts rbase from the server. The server is a dedicated computer server very fast with SCSI drives. I also have a brand new CSCO switch and I even replaced all network cards with 10/100mbs on all workstations. Rbase still runs very slow on the network. When the same application is run on a local computer (on c: drive) rbase is very fast. My application was tested by RBASE. (Razzak was very helpful in this situation). Unfortunately for me my application was OK on their network which has a very similar setup to mine. So it all points to my setup of the network. With Razzak's suggestions I improved the speed in certain areas by rewriting my code and using different programming ideas. One thing that works well and speeds up rbase is when I use Terminal Server Connection, big difference in speed. But is there anyone that would have any idea what my problem is too? Mark Kwoka -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Tuesday, September 14, 2004 10:56 AM To: RBG7-L Mailing List Subject: [RBG7-L] - slow computer 2 computer network, connected peer to peer 100mbs switch. both computers are W2K. The second computer, we just added, is about half the speed as the original (the original is the server). The second computer is brand new, both are p4 2.3GHz Running update 77 on both. Any suggestions on how to speed it up? Bernie Lis
