Re: Win 2K pro performance

[Emmitt Dove]

The one thing I found that made a huge difference is using parenthesis around the conditions in WHERE clauses.

e.g.:

        SELECT this FROM sometable INTO somevar WHERE column1 = avariable AND column2 = thisvalue

will run very slowly.  However:

        SELECT this FROM sometable INTO somevar WHERE (column1 = avariable) AND (column2 = thisvalue)

results is significant speed increase, but only if the columns are properly indexed.  This will be especially true in multiple-table selects used in cursors and views.

Try this, too:  Our W2k server runs 10/100 ethernet.  I can copy a 5 meg file from/to the server in under 2 seconds.  If your copy takes significantly longer, you need to be looking at the server, including such things as the NIC and its drivers.

We recently installed Windows 2000 Server and upgraded Rbase 6.1a to 6.5++
and have experienced a tremendous slowdown when changing menus.

The problem exists with both rbase versions and I'm new to this list.  Can
anyone tell me if it has been addressed or point me in the right direction?

Thanks!
Adam Crawford
Northwest Collectors
847-255-8300

Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT  06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]