Look at MATPARSE A11 = DCOUNT(IN.TAB,@AM) DIM RECS(A11) MATPARSE RECS FROM IN.TAB, @AM
FOR A1 = 1 TO A11 CUST.NUM = RECS(A1)<1,1> CUST.DESC = RECS(A1)<1,2> NEXT A1 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Laansma Sent: 17 November 2008 18:10 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/ ----------------------------------------- ********************************************** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ********************************************* ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
