If the array IN.TAB is only attributed, with say the customer number &
description with pipe delimited you can use REMOVE:
LOOP
REMOVE IN.LINE FROM IN.TAB SETTING MORE
UNTIL IN.LINE = "" DO
CUST.NUM = FIELD(IN.LINE,"|",1)
CUST.DESC = FIELD(IN.LINE,"|",2)
REPEAT
--------------------------------------------------
From: "George Gallen" <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2008 7:05 PM
To: <[email protected]>
Subject: RE: [U2] Speeding up processing through large dynamic table
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/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
