Thanks Razzak
I am trying to do my best to blow their socks off when I update my users
to V8.
I still have a few features they have requested that are slowing me down
but hope to be ready soon.
Marc
----- Original Message -----
From: "A. Razzak Memon" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, March 23, 2009 10:47 PM
Subject: [RBASE-L] - Re: R:BASE V-8 network speed
At 12:08 PM 3/23/2009, Marc Shluter wrote:
What are the best settings for speed using V8 on a small network?
Marc,
In addition to STATICDB ON, FASTLOCK ON, make sure to keep the default
"SCRATCH TMP" settings in RBENGINE8.CFG file.
A properly designed and normalized database with correctly implemented
constraints, such as PRIMARY KEY, FOREIGN KEY, PRIMARY KEY REFERENCED,
and NOT NULL should also help improve the speed.
In a multi-table one-to-many form, make sure that all involved tables
are properly listed in order of table relation.
Every column involved in a "WHERE colname =" clause should be INDEXed
accordingly.
Every joining/linked column(s) involved in a "VIEW" should be INDEXed
accordingly.
Tip:
When upgrading/converting to R:BASE Turbo V-8 for Windows, make sure
to re-build the entire database, as strongly suggested in Getting
Started Guide.
Additional Resources:
From The Edge: http://www.razzak.com/fte/
. Gaining Speed with Programming
. Database Maintenance
. Problem Solving in R:BASE
Very Best R:egards,
Razzak.
