Thanks for the thanks. Mark Johnson I'm curious of the DIM A(50000) method on other platforms. I dare not try it on my Microdata clients. ----- Original Message ----- From: "Tom Dodds" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, August 22, 2005 11:31 AM Subject: RE: [U2] REMOVE results as promised.
> Thanks Mark. Great job. You can satisfy some of the people some of the > time but you can never satisfy all of the people all of the time. > > This obviously took some time to do and I appreciate the effort. > > Tom Dodds > [EMAIL PROTECTED] > 630-235-2975 > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson > Sent: Sunday, August 21, 2005 11:28 AM > To: [email protected] > Subject: [U2] REMOVE results as promised. > > As promised, here are the results of 9 different methods of appending. > Basically program went like this: > > A="" > FOR I=1 TO 50000 > A<1,-1>=I > NEXT I > > Style 1: <1,-1> > straight.......................................................1 minute, 29 > seconds > Style 2: <-1> attribute level then CONVERT to > 253...............................41 seconds > Style 3: DIM(50,000), MATWRITE, READ & CONVERT.............................2 > seconds > Style 4: DIM(50,000), then assign to variable and CONVERT to > 253............1 second > Style 5: Target = null, [] > replacing........................................................40 seconds > Style 6: Target=Space(1000000), [] replacing then TRIM........8 minutes, 55 > seconds. > Style 7: Append, VM assigned inside > loop..............................................41 seconds > Style 8: Append, VM assigned outside loop then remove > last..................34 seconds. > Style 9: <1,MV> with MV+=MV as pointer.............................1 minute, > 28 seconds > > 60 user D3 system on W2000 during normal business day. > > It appears that Styles 3 & 4 escaped the suggestions and rose to the top. > Apparently the CONVERT (or RAISE/LOWER) functions are pretty quick. The DIM > is incredibly quick. > > I learned a lot and hope others can as well. > Thanks for everyone's suggestions. > Mark Johnson > > If anyone wants further coding for any of the styles then don't hestitate to > ask. > ------- > 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/
