I wrote something about this a while ago. Dynamic arrays can be a major performance hit on a system if the size gets more than a few thousand elements. We had processes building huge dynamic arrays using LOCATE/INSERT. Some of them ran for a week. We changed to using a work file to write a record on a file, with the key being the data we were doing the LOCATE on. The programs that ran for a week with dynamic arrays finished in about 10 hours using a well sized work file. -Rod
-----Original Message----- From: Trevor Ockenden [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 8:56 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Dimensioned arrays > I am trying to find the best way to update a dimensioned array where any > updates/changes are inserted to the beginning of each associated field My 2 cents worth is to convert the dimensioned array into a dynamic array then perform your inserts then convert back. Refer to MATPARSE and MATBUILD statements. Dimensioned arrays are not ideal for this type of data manipulation whereas dynamic arrays are perfect. Horses for courses! Cheers Trevor Ockenden m: 0414 731 634 e: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, 4 November 2004 11:26 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [U2] Dimensioned arrays __________________________________________________________________ << ella for Spam Control >> has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
