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