|
Hello Victor-
Is their a wrong way to do an index?
Lee
----- Original Message -----
Sent: Monday, July 10, 2006 10:55
AM
Subject: [RBASE-L] - Re: What's up with
this?
Check your indexes. Having this done correctly make a big
difference.
Lee Bailey wrote:
>
> Hello
All-
>
> I’ve been monitoring the users group for a long time, and
have been
> impressed with the expertise revealed in exchanged emails.
I am hoping
> that one of you networking gurus can point me in the
right direction
> in solving a perplexing problem.
>
> I
have been an avid R-Base user since DOS 2.0. I am currently running
>
version 6.5, and have been for about 5 years.
>
> Here’s the
setup—
>
> Machine #1 is a 2.2 gighz 64 bit machine with 2 gig’s
of ram. Machine
> #2 is a 1.9 gighz 32 bit machine with 1 gig of ram.
Both machines are
> tied together via a router with a transfer rate of
100 mbps. The
> router also provided access, by both machines, to the
Internet via a
> DSL modem, also attached to the
router.
>
> The 20 meg database files (RB1, RB2, RB3, and RB4) are
on machine #1,
> with application command files on both machines to
speed processing in
> the common database. Being an old R-Base guy,
much of the programming
> is done via command files, crunching a lot of
data, to achieve the
> full relational data base power.
>
>
Here’s the problem--
>
> When machine #1 accesses the database as
a sole user, the
> applications, command files, forms, reports, etc.
run very quickly.
> When machine #2 accesses the database solely,
applications also run
> very quickly. When both machines are utilizing
the database
> simultaneously, machine #1 still works great (the data
base is on this
> machine), but machine #2 drops to a painful
crawl.
>
> If both computers are utilizing the database, and
machine #1 exits the
> database, machine #2 continues to work painfully
slow, even though it
> has become the sole user of the database at that
time.
>
> Setting are: staticdb on, fastfk off, scratch off, multi
on, ansi off,
> feedback on, rules off, rowlocks are used, column
verify, and
> precedence on, sort menu on.
>
> My thought
is that at a transfer rate of 100 mbps between the
> machines, a slow
response by machine #2 should never happen—no matter
>
what.
>
> Any ideas as to what is going on, and what can be done
to rectify the
> situation?
>
> Lee
> Bailey &
Associates
> E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Phone:
772-597-0040
> Fax: 772-597-0043
--
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
|
