Also:
12. Make sure your rbase.cfg has:
ROWLOCKS ON
FASTLOCK ON
You should also read up on and play with the QUALCOLS setting.
Lee,
The problem is a Microsoft thing. Any time on an MS network with
the database on an MS server, more than one user experiences
slowdown. To combat this, there are a few steps to take:
1. Use a gigabit link between all your machines.
2. Use a switch downstream from the router.
3. Try to use hardware that supports full duplex. Check your cards
to see if they're operating full duplex, and if not (and set to
AUTO), try forcing full duplex.
4. Use quality cables.
5. Make certain each user has scratch files set to their local drive.
6. Run with STATICDB ON.
7. Make certain the box holding the files is set to optimize for
background services not applications.
8. Don't use the box holding the files for anything else.
9. Don't use peer-to-peer; install a domain controller (not on the
file server).
10. Install R:Base locally on each client.
11. Run, don't walk, to 7.5, Windows not DOS.
Now, these are all in the nature of suggestions, but are things
we've found improve the responsiveness.
Have you experienced the same types of difficulties when employing
your applications in a network scenario? What do the "big boy"
clients do to avert this issue?
Thanks to all!
Lee
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
37 Sybil Ave
Branford, CT 06405
(203) 643-8022
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
37 Sybil Ave
Branford, CT 06405
(203) 643-8022
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
