What if you eliminated the SWAP and changed: CUST.NUM = IN.LINE<1,1> CUST.DESC = IN.LINE<1,2>
How long does it take? George > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of David Laansma > Sent: Monday, November 17, 2008 1:10 PM > To: [email protected] > 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
