So the remove pointer (mark) works like the example believes it should... ---- SWAP @VM WITH CHAR(0) IN IN.TAB LOOP REMOVE IN.LINE FROM IN.TAB SETTING MARK SWAP CHAR(0) WITH @AM IN IN.LINE * SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> WHILE MARK DO REPEAT
Marvin R. Fisher Technical Resource Group A Pipeline Group Company 2850 Red Hill Ave. Suite 110 Santa Ana, CA 92705 Tel (949) 296-8380 ext. 620 Fax (949) 756-0029 Pipeline Software Statement: This email message is confidential and may be legally privileged. The contents contained within, including any attached files, are intended solely for the addressee(s). Access by anyone other than the addressee(s) is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action, taken or not taken, in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email message in error, please contact the sender. Any views expressed within are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Pipeline-Software, Inc., Santa Ana, CA. (The contents of this email message have been scanned for the presence of computer viruses.) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua Gallant Sent: Monday, November 17, 2008 10:31 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Speeding up processing through large dynamic table When running through an array with a for next loop the last item processed isn't remembered so the program needs to traverse the entire array for each record and will slow down as you get to records later in the process. Instead of this: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.TAB<A1> SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> NEXT A1 Try something like this instead: LOOP REMOVE IN.LINE FROM IN.TAB SETTING MARK SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> WHILE MARK DO REPEAT That will keep track of where you were in the array and pick up where you left off. Let me know how that works out for you. Thanks, Josh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Laansma Sent: Monday, November 17, 2008 1:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Speeding up processing through large dynamic table Is there a way to speed up spinning through a very large dynamic table? Here is a sample of my program: A11 = DCOUNT(IN.TAB,@AM) FOR A1 = 1 TO A11 IN.LINE = IN.TAB<A1> SWAP @VM WITH @AM IN IN.LINE CUST.NUM = IN.LINE<1> CUST.DESC = IN.LINE<2> NEXT A1 A11 is 85,000+ and as this loop goes on, this thing get really slow. Any tips on speeding this up? ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/