well I haven't done a ton of testing on speed with and without themes but the
whole theory with this set up, as I understand it (and I'm not much of a system
admin so please excuse my terminology), is you're putting the horse power on
the workstation rather then the server. If it's on the server the horse power
would need to be transferred from the server threw the network to the
workstation and run, so I 'think' this will speed things up at least a little
bit...
Before you compile, I'm sure in your start up file you have the
CONNECT [DBName] IDENTIFIED BY ....
change that to
CONNECT [//NetworkShareNameToDBServerDir/SubFolder/DBName] IDENTIFIED BY ...
and compile that..
then copy everything, other then four .RB# files and any external eeps, to the
user work station (I general put it all in a folder name {App Name}UserFiles
and copy that folder to the workstation's Program Files folder, create a short
cut of the .exe, move the short cut to the Doc & Settings > All User's >
Desktop folder and that's it!! The only kinda, bugger is when there are RBase
updates and you have to copy all the new .RBL files to ALL the workstations
rather then just one place on the server but that isn't a biggie for me.
OH and another thing if you use any external eeps, you'll need to get the DB
current directory just prior to running one and build that path. Here's some
code I've used...
SET VAR vCurrDir text =(CVAL('DBPATH'))
set var vCurrDB text=(CVAL('DATABASE'))
SET VAR vCurrDir text =(.vCurrDir+'.db')
SET VAR vCurrDir =
(SRPL(.vCurrDir,('\'+.vCurrDB+'.db'),'',0)+'\'+.gvEepFldrRptStat+'\' )
SET VAR vchkfile INTEGER= (CHKFILE(.vCurrDir))
IF vchkfile = '1' THEN
SET VAR vruneep =(.vCurrDir +'Rpt_Stat0ProdRptAdv.eep')
RUN &vruneep
CLEAR VAR vruneep
ENDIF
Another benefit I found with this set up is when I only have one or two
workstations that require a plug in, I'll can purchase a couple plug in
licenses, put the plugin in the same user folder, and when the user gets to
section that uses the plugin, I check to see if the plugin file exists, if it
does run it else alert the user that they don't have it and can't continue till
one is purchased for the workstation.
Have a Fabulous Day!
Rachael M.
Freelance Developer
www.DragonflyDevelopmentMN.com
----- Original Message -----
From: Marc
To: RBASE-L Mailing List
Sent: Monday, March 17, 2008 9:40 AM
Subject: [RBASE-L] - Re: Themes?
Rachael
>>have the Complier files on the user workstations pointing back to the four
database files on the server.
What exactly did you do for this? I have all the files in 1 folder, compiled
EXE and .RB*, I know which files to move
to the workstation but I am not sure how to point them back to the RB* files?
Also, would this help the workstation speed very much even without Themes?
Thanks
Marc
----- Original Message -----
From: Rachael Malberg
To: RBASE-L Mailing List
Sent: Monday, March 17, 2008 7:25 AM
Subject: [RBASE-L] - Re: Themes?
Good point Jan but I'm going to disagree with your #3. That issue is
totally dependent on how you set up your complied app. I'm using a
combination of three themes, One to ID regular data entry forms (R:Base
Rocks!), one for look ups (One Cyan) and one for Alert forms (Orange Glass).
I too had noticed the slow down and then John and a few others on list
suggested I set it up to have the Complier files on the user workstations
pointing back to the four database files on the server. So tried it and wow!
the start up and theme response is just like a full install on each workstation
without a bit of network change.
Have a Fabulous Day!
Rachael M.
Freelance Developer
www.DragonflyDevelopmentMN.com
----- Original Message -----
From: jan johansen
To: RBASE-L Mailing List
Sent: Monday, March 17, 2008 8:05 AM
Subject: [RBASE-L] - Re: Themes?
Lin,
Not to discourage the use of Themes but there are some things you need to
consider when
using themes.
1. Is this a single user application?
If yes use themes to your hearts content.
2. If multi-user application are you using full R:Base installed on each
workstation?
If yes use themes to your hearts content.
3. If you are in a multi-user environment and using the R:Compiler then;
a. Make sure your network connections are fast. Although 100MBS
sounds fast
a theme like Sports Blue can take about 1.5 seconds to load. 1 GB
network is
much better.
I was recently frustrated by a V8 upgrade by apparent loss of user speed.
However I
tracked it down to my network speed. I have a network hub at 1GB but my
users had 100MB cards.
20 new cards from newegg.com for $12 each saved a lot of frustration.
Jan
-----Original Message-----
From: "Lin MacDonald" <[EMAIL PROTECTED]>
To: [email protected] (RBASE-L Mailing List)
Date: Sun, 16 Mar 2008 05:30:24 -0700
Subject: [RBASE-L] - Themes?
Is there any way to modify Themes at all? If I want to change the
colors of a theme, is that possible? What if I want to create my own theme and
use it throughout my Application. Is there any way to accomplish that?
Lin
