Javier,
The portion of the configuration startup file was for a different user.
As you know, different applications use different environments, and
that user was not implementing STATICDB.
John
At 09:13 PM 10/5/2010, you wrote:
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
