You can SELECT dynamic arrays too.
This is a BASIC SELECT not the executed TCL verb!
The beauty is it works only on attribute marks, so it should even return
multi-valued strings.
I use this technique to go through large multi-valued attributes too.
I just assign the attribute to an array, convert @VM to @AM and then
SELECT the array.
It is not good with multiple dependent attributes, though, even one
could do multiple SELECTTV TOs and READNEXT FROMs.
But I think it is bad database design to have those in the first place -
better write them as items to a file.
Marvin R. Fisher wrote:
But it is not a file - it's an array.
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 Mecki Foerthmann
Sent: Monday, November 17, 2008 11:21 AM
To: [email protected]
Subject: Re: [U2] Speeding up processing through large dynamic table
READNEXT could be an option
SELECT IN.TAB
LOOP WHILE READNEXT IN.LINE DO
CUST.NUM=IN.LINE<1,1>
CUST.DESC=IN.LINE<1,2>
REPEAT
this should be lightning-fast regardless how big IN.TAB is.
David Laansma wrote:
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/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
