Sharon,
I find that most of the speed issues are related to the location of the scratch files. Make sure that the scratch files (temporary files) are located on the users workstation and not the server. Scratch files on the server cause a lot of unwanted network traffic. I am not sure why this would be more of an issue under 2000 as opposed to Novel. If the database structure and code are efficient, scratch files are local, and the database properly indexed, speed should not be an issue. See the SET SCRATCH syntax on www.rsyntax.com.
Hope this helps.
Best Regards
Rich Young
Advance Business Systems
10755 York Road
Cockeysville, Maryland 21030
(410) 252-4800
[EMAIL PROTECTED]
-----Original Message-----
From: SHARON LIMA [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 10:58 AM
To: Rbase List
Subject: Network Stations SLOW
I frequently get questions from clients who use my application
in a network environment using R:Base RUNTIME 6.5 for Windows. I do
not have any training in network issues so I need some guidelines
to pass on to my clients. Is there a list of suggested settings
and recommendations for networks?
A current problem that a clients has called about:
They recently replaced their Novell 3.12 network with a Windows 2000
server network.
Now to run the R:Base application across the network it is VERY SLOW.
The confusing
thing is that it is not always slow. Rebooting doesn't help.
The only suggestion I gave was to set the FILES in RBASE.CFG to a higher
number...did not help. They reinstalled the application and the runtime
file and it worked better for awhile.
Now it is SLOW again. Two of six computers are fine while the other
four are SLOW. One of the slow computers is a new PIII-800 while one of
the faster computers is a Pentium-166.
They do not feel that it is a network problem because all computers go
through the same hub.
The slowness is evident in both starting up the application and then
moving around and accessing data once started.
Thanks for any help you can give.
Sharon Lima
