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

[TOM HART]

I have had the same problem.  My solution was to upgrade to gigabyte switch and 
cards.  With those installed my network computers are almost as fast as my main 
computer.  All I need to do is upgrade at my other locations.
Tom Hart




________________________________
From: mike epstein sony viao office <mepst...@epsteintheplumber.com>
To: RBASE-L Mailing List <rbase-l@rbase.com>
Sent: Sat, July 10, 2010 4:22:22 PM
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