John: The AUTONUM step is what is consistently taking so much longer to complete. As an aside, I performed an "UNLOAD ALL" reload sequence using Razzak's recommendation prior to running these tests.
Here is the test code which is being applied to my PRODMAST table: Results using eXtreme 9.1: DROP INDEX PM_SEQ_IDX SET VAR VDPP_T1 TIME = .#TIME AUTONUM SEQNUM IN PRODMAST USING 1656217 1 NUM AUTONUM SEQNUM IN PRODMAST DELETE SET VAR VDPP_T2 TIME = .#TIME CREATE INDEX PM_SEQ_IDX ON PRODMAST (SEQNUM) RETURN SHOW VAR VDPP_T% Columns have been updated in 418619 row(s) in PRODMAST Variable = Value Type -------------------- ------------------------------ ------- VDPP_T1 = 14:00:34 TIME VDPP_T2 = 14:06:29 TIME Elapsed time: 5:55 ===================== Results using Turbo V-8: DROP INDEX PM_SEQ_IDX SET VAR VDPP_T1 TIME = .#TIME AUTONUM SEQNUM IN PRODMAST USING 1656217 1 NUM AUTONUM SEQNUM IN PRODMAST DELETE SET VAR VDPP_T2 TIME = .#TIME CREATE INDEX PM_SEQ_IDX ON PRODMAST (SEQNUM) RETURN SHOW VAR VDPP_T% Columns have been updated in 418619 row(s) in PRODMAST Variable = Value Type ------------------ ------------------------------ ------- VDPP_T1 = 14:09:34 TIME VDPP_T2 = 14:10:02 TIME Elapsed time: 28 seconds Any thoughts or suggestions? Thanks -- Mike Ramsour From: John Minyo II <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: 04/27/2011 11:35 AM Subject: [RBASE-L] - Re: eXtreme 9.1 performance vs. Turbo V-8 Sent by: [email protected] At 10:03 AM 04/27/11, [email protected] wrote: To convert to eXtreme I did an: 1. UNLOAD ALL using Turbo V-8 and then 2. Copied the ".all" and ".lob" files to a new directory 3. Used eXtreme 9.1 to RUN maindata.all I didn't use the FEEDBACK options. I will try that to see if anything shows up. Hello Mike, In addition to the routine suggested by Razzak, make sure that R:BASE eXtreme 9.1 (64) has been added as an exception with all anti-virus software, like you have likely already done with R:BASE Turbo V-8. Best regards, John Minyo II R:BASE Technologies, Inc. Customer Service Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
