----- Original Message -----
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
>