[RBG7-L] - RE: Windows 2000 Server

[Bernard Lis]

Is your network using a hub or a switch? If you replace the hub with a switch, you will see a great improvement in performance. Bernie Lis ----- Original Message ----- From: Joel Solomon To: RBG7-L Mailing List Sent: Thursday, June 30, 2005 12:05 PM Subject: [RBG7-L] - RE: Windows 2000 Server Thanks for all the ideas.  I will try and see if the problem persists ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Thursday, June 30, 2005 11:46 AM Subject: [RBG7-L] - RE: Windows 2000 Server Joel,   Scratch ON means all temporary files for sorting etc. are generated on the same drive/path as the database.  Which means the PC has to send all that data back and forth from it's processor to the server drive since your database is on the server.   Setting  Scratch OFF will place the temporary files on the work stations current drive\path (which is usually the database's server drive resulting in the same issue)   Set Scratch c:\Windows\Temp (XP) will place these files in the Windows temp directory on your local machine and thus avoid the network traffic.  Also windows will clean these files up automatically if scheduled.  It is often best to set this in the CFG file so it is set before startup.  This may assist in your overall speed.   The -a option is used such as "RBASE.EXE -a  Rbase.dat" in the program setup on your desktop shortcut ICON.  It tells Rbase that the Rbase engine files do not reside on the workstation, but on the server and to not look in the System32 directory etc.  This is used only if you do not have the engine files on the workstation.   -Bob   -------------- Original message -------------- > Dawn, > > I am running Rbase with the data files on the server and Rbase running from > the workstations. Scratch is on and is set the local machines. I'm not > sure what the -a option is or how to use it. > > Thanks > Joel > > ----- Original Message ----- > From: "Dawn Oakes" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" > Sent: Thursday, June 30, 2005 11:08 AM > Subject: [RBG7-L] - RE: Windows 2000 Server > > > Joel, > I can tell you that I have Rbase on a Win2k server accessed by a dozen > or more users at the same time without any trouble. > > Are you running Rbase with the files on the workstations or at the > server with the -a option? Is scratch on or off? > > The only time I had trouble with major speed differences with multiple > users was when my tables weren't indexed properly. Check / pack your > indexes or you may want to do a reload, if you haven't done one > recently. > > Dawn > > -----Original Message----- > From: Joel Solomon [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 30, 2005 10:41 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Windows 2000 Server > > Good Morning All, > > I would like to know if anybody has experienced a problem with Windows > 2000 server and Rbase in the mutil user mode. It seems that when I have > one user logged in the system runs fine but if more than one person is > logged in the system runs extremely slow. > > For instance, a simple command file runs in about 10 seconds with one > user login in but it takes over 95 seconds if two or more are logged in. > Does this sound like an Rbase or Windows issue? If it sounds like a > windows issue, does anyone have suggestions as to what to check at the > server level. > > I have already checked all cables and switches. The server seems fine > in all other applications > > Thanks > > Joel Solomon > V.P. Finance > Barbizon International >