Razzak, Do I assume correctly that if I am in a mixed RBDOS/RBWIN environment that I cannot make this change until RBDOS is updated to use the new style indexes?
Thanks, Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Wednesday, September 17, 2008 8:48 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: R:BASE 7.6 and Turbo V-8 Updates(09/17/2008) 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.
