[RBASE-L] - Re: staticdb writechk qualcols fastlock settings

[jan johansen]

Mike,

I understand the frustration about running over a network.
My current settings are
STATICDB ON
QUALCOLS 2 (rowlocking you have to read up to determine whether page locking 
or row locking is better for you)

I think I would turn off WRITECHK. The default is off.

Jan
 


-----Original Message-----
From: "mike epstein sony viao office" <mepst...@epsteintheplumber.com>
To: rbase-l@rbase.com (RBASE-L Mailing List)
Date: Sat, 10 Jul 2010 16:22:22 -0500
Subject: [RBASE-L] - staticdb writechk qualcols fastlock settings


Good Evening
 
I have been having problems with speed over a network . Especially with the 
startup . It takes seconds to bring up the external form (main menu) when 
there are no other users on the network. I wonder if my computer might be 
the problem , I am using windows xp and have a sony vaio Processor           
     x86 Family 6 Model 13 Stepping 8 GenuineIntel ~1729 Mhz Total Physical 
Memory  2,048.00 MB Page File Space       2.58 GB. 
 
I have played with the settings listed in the subject line and it seems that 
the best settings for my application are 
 
Staticdb on  Fastlocks on qualcols 10 writechk on
My desktop shortcut reads C:\RBTI\RBG90_64\RBG90_64.exe exe-o rbase.dat
The rbase.dat file 
   CLEAR ALL VARIABLES
LABEL StartFresh
   DISCONNECT
   SET QUOTES=NULL
   SET QUOTES='
   SET DELIMIT=NULL
   SET DELIMIT=','
   SET LINEEND=NULL
   SET LINEEND='^'
   SET SEMI=NULL
   SET SEMI=';'
   SET PLUS=NULL
   SET PLUS='+'
   SET SINGLE=NULL
   SET SINGLE='_'
   SET MANY=NULL
   SET MANY='%'
   SET IDQUOTES=NULL
   SET IDQUOTES='`'
   SET CURRENCY '$' PREF 2 B
   DISCONNECT
   SET STATICDB OFF
   SET ROWLOCKS ON
   SET FASTLOCK OFF
   SET TIMEOUT 120
   SET FEEDBACK OFF
LABEL Start
   CLS
set staticdb on
SET FASTLOCK ON
   CONNECT plumber IDENTIFIED BY NONE
   -- Enforce Default Settings
   set qualcols 10
   SET WRITECHK ON
   SET QUOTES='
   SET DELIMIT=','
   SET LINEEND='^'
   SET SEMI=';'
   SET PLUS='+'
   SET SINGLE='_'
   SET MANY='%'
   SET IDQUOTES='`'
   SET CURRENCY '$' PREF 2 B
   SET NULL ' '
   SET ZERO ON
   SET DATE FORMAT MM/DD/YYYY
   SET DATE SEQUENCE MMDDYY
   SET DATE YEAR 30
   SET DATE CENTURY 19
   CLS
REFF PLUMBER.RFF
RETURN
 
 
 
The application seems to run ok but as I stated it can take 30 seconds or 
more from the desktop shortcut click before the external form loads . 
Somewhat similar to version 2.1 . 
 
Any comments 
 
Mike