John,
In a post dated 6/24, R:azzak posted a suggested start-up file. A portion of
the file reads:
.
SET CURRENCY '$' PREF 2 B
DISCONNECT
SET STATICDB OFF
SET ROWLOCKS ON
SET FASTLOCK OFF
SET TIMEOUT 120
SET FEEDBACK OFF
LABEL Start
CLS
CONNECT mydbname IDENTIFIED BY NONE
-- Enforce Default Settings
SET QUOTES='
.
You can see that the STATICDB and FASTLOCK are different than yours. I
understand that the STATICDB setting prevents changes to the structure while
allowing creation of temporary tables/views, but does it affect network
speed?
How do the ROWLOCKS and FASTLOCKS settings affect network performance? I use
the settings above in my start-up and maybe I need to tweak my settings???
Javier,
Javier Valencia, PE
913-829-0888 Office
913-915-3137 Cell
913-649-2904 Fax
<mailto:[email protected]> [email protected]
_____
From: [email protected] [mailto:[email protected]] On Behalf Of John Minyo
II
Sent: Tuesday, October 05, 2010 3:58 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - re: network trouble
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
