At 03:52 PM 10/5/2010, you wrote:
I have developed an application in R:base 9.0 (64) under Win 7.
This application runs fine and fast when run on one PC.
the latest version of R:base is installed on my PC's.
When I put two recent PC's in a network via a 100 Mbit/sec switch,
with the database in a shared directory on PC A, it still runs well
on PC A, but when I log in from PC B, it goes SLOW on this PC and
eventually locks up, so that I have to restart R:base on PC B.
(PC A : 6 GB RAM, 1 Tb HDD...PC B : 4GB RAM and 500 MB HDD)
I don't dare to image what a disaster this could in a small network
with 5-6 workstations.
It must be that I am overlooking something in the network setup.
Could anyone give me 'to do'list on what to do exactly and in what
order so to get a workable network application.
This network thing is the last step I have to make in my conversion
from Access to R:base.
(sometimes I begin to regret I didn't stick with Access...as far as
this network thing is concerned)....
Any help would be greatly appreciated....
Hello Luc,
When establishing the database and application in a multi-user
environment, there are considerations to make. Within the Help
documentation you will find a chapter "Multi-User Considerations"
which details settings that can be used.
To summarize, the SCRATCH setting is very important in that each
users temporary files must be stored locally. The following is the
correct syntax to do so.
SET SCRATCH TMP
Next, to reinforce the live database to be established in a
non-editable structure mode and to increase overall speed, the
following should be used in the main startup file location.
DISCONNECT
SET MULTI ON
SET STATICDB ON
SET FASTLOCK ON
SET QUALCOLS 2
CONNECT dbname
Best regards,
John Minyo II
R:BASE Technologies, Inc.
Customer Service
