At 08:36 PM 9/17/2008, Lawrence Lustig wrote:
<<
connection methods as well as the speedy indexes in a true
multi-user environment.
>>
May I ask under what circumstances are the indexes speedier,
and are their any tips for constructing our indexes to get
full advantage of the newest speed enhancements?
Well, if I reveal the development details, along with internal
engine enhancements, I will also be spoiling the scheduled
presentations by members of R:Dream Team at the R:BASE Technologies
10th Anniversary Developers' Conference exactly one month from now.
http://www.rbase.com/conference/highlights.php
Having said that, be your own judge and perform a few obvious tests
yourself and see what you find.
For example, take your most critical and biggest database you have
ever used or worked on, and follow the very simple steps outlined
below:
-- R:BASE Turbo V-8 for Windows Database:
01. Note the current size of your dbname.rx3 file
02. Using the previously installed update:
CONNECT dbname
{
Perform some quick tests to retrieve a large set of records
based on indexed column(s)
}
OUTPUT dbname.ALL
UNLOAD ALL
OUTPUT SCREEN
DISCONNECT
RENAME dbname.rx? dbbackup.rx?
EXIT
03. Download the latest update of R:BASE Turbo V-8 for Windows
(Build: 8.0.18.30919)
http://www.rupdates.com/rbg8
or
http://www.rupdates.com/rbg8/enterprise
04. Verify the provided Checksum to make sure that the file is
downloaded and saved correctly.
05. Apply the update accordingly.
06. Start R:BASE Turbo V-8 for Windows (Build: 8.0.18.30919)
HELP About
Verify the version and build
07. Switch the current folder to appropriate place with
dbname.all and dbname.lob files (created at step 02).
At the R> Prompt:
SET FEEDBACK ON
RUN dbname.ALL
-- watch the speed of building those indexes
SET FEEDBACK OFF
DISCONNECT
-- Note the current size of dbname.rx3 file
CONNECT dbname
{
Perform some quick tests to retrieve a large set of records
based on indexed column(s) and note the difference between
the one performed at step 02.
}
08. Now place this freshly built database (.rx1-rx4) using the
latest update on the network drive.
09. Update all workstations on the network and make sure that
everyone is in sync with the same RBG8.exe and RBEngine8.DLL.
10. Perform the same tests and see what you find as compared to
the previous versions.
Although our focus was to fine-tune the needed performance for
Turbo V-8, you may repeat the same exercise using R:BASE 7.6
for Windows, accordingly.
http://www.rupdates.com/rbg76
http://www.rupdates.com/rbg76/enterprise
Enjoy these special updates and stay tuned for the whole new
R:BASE eXtreme (version 9.0), to be officially unveiled at the
10th Anniversary Developers' Conference.
http://www.rbase.com/conference/
The BEST is yet to come!
Very Best R:egards,
Razzak.
