That's been my "temporary" fix: CONVERT @VM TO "," IN REC WRITE REC ON F.TMP,TMP.KEY1 EXECUTE "! sort -t, +4nr /tmp/":TMP.KEY1:" > /tmp/":TMP.KEY2 READ REC FROM F.TMP,TMP.KEY2 ELSE NULL CONVERT "," TO @VM IN REC
I'm going to try the Shell Sort that's on the PickWicki and see if I can modify it to work .. My question now is: how big can you dimension arrays? .. if DCOUNT(REC,@AM) = 10000, will the MatParse work? .. (it did - I tried it) .. It also worked for 100,000 .. But what's my limit and what will that do to my performance and memory usage? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Rubeor Sent: Monday, July 26, 2004 10:46 AM To: [EMAIL PROTECTED] Subject: RE: [U2] merge sort Do you need this for a unix platform? This would not qualify as a generic BASIC merge/sort, but you could shell to the unix sort command for this sort of stuff. -----Original Message----- From: Chuck Mongiovi [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: RE: [U2] merge sort I want a merge sort for data in BASIC, not lists. For example ("]" is an @VM) REC<1> = A]B]C]D]15 REC<2> = A]B]C]D]25 REC<3> = A]B]C]D]100 REC<4> = A]B]C]D]11 I want to sort by multi-value #5 .. The sorting isn't the issue .. It's when DCOUNT(REC,@AM) gets large that the whole process gets extremely slow .. I can't do something like MATPARSE, because I can't predict *HOW* big REC will get .. Anyway, I have a sneaking suspicion that it's already been done before, so I'm trying to avoid re-inventing the wheel .. -Chuck -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rosenberg Ben Sent: Friday, July 23, 2004 6:34 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] merge sort EXECUTE "MERGE.LIST 0 UNION 0 TO 0" will sort and de-dupe the current select list. > -----Original Message----- > From: Chuck Mongiovi > > Does anyone know where I can get code for a generic BASIC Merge SORT > routine? > -Chuck > ------- The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. ------- 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/
