Index columns that are being used for lookups. I will Index things like
PO number in Descending order with the thought that im not going to be
looking up very old PO's. Or maybe you have not indexed anything (I did
this on a table and it took me a day or 2 to figure out way the app was
so slow). I still go back and look at code and see how I can make it
better with either a index or a code redo. The other thing that seems to
help a lot is using temp tables. They run local so they are much faster.
I took one report that was running on a old laptop in our warehouse from
5 minute run time to about 30 seconds using temp tables. I learned from
Dennis McGrath that you can index a temp table also, just do it after it
has be populated with your data. A friend of mine once told be to check
the simple stuff first before you start into the hard stuff. Checking
indexes and Code to me is easier that dealing with servers and how your
network is setup.
Lee Bailey wrote:
Hello Victor-
Is their a wrong way to do an index?
Lee
Bailey & Associates
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Phone: 772-597-0040
Fax: 772-597-0043
Web Site: www.BaileyUS.com <http://www.BaileyUS.com>
----- Original Message -----
*From:* vtimmons <mailto:[EMAIL PROTECTED]>
*To:* RBASE-L Mailing List <mailto:[email protected]>
*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]>
<mailto:[EMAIL PROTECTED]>
> Phone: 772-597-0040
> Fax: 772-597-0043
--
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
--
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
