Good morning! I'm finally making the time to test eXtreme v91 before converting over from Turbo V-8. Really looking forward to using the tons of new features.
I have a program that refreshes and adds new data to a 400,000+ row, 45 column table. My routine drops the indexes before adding the data and then rebuilds them. It also AUTONUMs a SEQNUM INTEGER column and then deletes the AUTONUM. Using duplicate copies of the database and program, Turbo V-8 runs the program in about a minute and a half. It takes eXtreme about 7 minutes to run the same program, almost 6 times longer. What should I be looking for to figure out why eXtreme is taking so much longer? Basic info: R:BASE v8.0 for Windows (32-bit), U.S. Version, Build: 8.0.24.31116 R:BASE eXtreme 9.1 (64), U.S. Version, Build: 9.1.3.10414 04/27/2011 08:57 AM 1,076,494 MAINDATA.RX1 04/27/2011 08:57 AM 4,671,799,296 MAINDATA.RX2 04/27/2011 08:57 AM 1,766,539,264 MAINDATA.RX3 04/27/2011 08:57 AM 1,929,216 MAINDATA.RX4 Windows XP Professional 32-bit Thanks for any insights. Mike Ramsour 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.
