Also,
I have noticed a big speed difference when having Norton anti virus installed
with the default settings.
So
this is what I did:
1. I
unchecked the "Run or opened" box under the "auto-protect".
2. I added the database directory to the exclusions
list.
3. I
added the wildcard "*.$$$" for the temp directory to the exclusions
list.
With
these settings my e mail and downloaded programs will still be checked(which is
how you get most of the viruses).
What a
difference!!
P.S.
If you used application express to create your menus and the menus are
different files then I can help. When every menu is opened it uses the
"connect" command to connect to the database. In multi user environment there
will be a delay when more than one user has connected. So every time you go to a
separate menu it has to reconnect to the database. Application Express puts this
in the start up block by default.
If you
are using only one database then I would suggest removing the connect and
disconnect(application express also puts this in too!!) commands from the
sub-applications and have it connect in the main application or in the rbase.dat
file.
Mult-user mode is always slower than single user as Albert
stated.
Dan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Emmitt Dove
Sent: Wednesday, August 29, 2001 9:45 AM
To: [EMAIL PROTECTED]
Subject: Re: Win 2K pro performance
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-8300Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
