A few years ago we used the BASIC SELECT FILE as opposed to the EXECUTE "SELECT FILE".
We updated UniVerse (don't ask from what version to what version as I don't remember) and overnight ALL our programs ran five or six times longer. We were told (by VMark) that the BASIC SELECT now selected each group but it could be optioned to work the "old" way. I wrote a conversion program to change ALL BASIC SELECTs to executed SELECTs in the source and recompiled and that is the way we have done it ever since. I don't know if things are different now but we have grown to prefer EXECUTEd selects as selection criteria can be included. My 2c worth. Louis ----- Original Message ----- From: "Mark Johnson" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Sunday, October 02, 2005 3:50 AM Subject: Re: [U2] Fw: More U2 programming hints : Here's what i meant initially and apologize for stating it ambiguously. : : Ineffecient: : OPEN "FILE" TO F.FILE ELSE STOP : EXECUTE "SELECT FILE" : LOOP READNEXT... : : More effecient : OPEN "FILE" TO F.FILE ELSE STOP : SELECT F.FILE : LOOP READNEXT... : : I try not to get code-y in examples but this should clear it up. : : Likewise : Extraneous : OPEN "FILE" TO F.FILE ELSE STOP : EXECUTE "CLEAR-FILE (DATA FILE" : : more effecient: : OPEN "FILE" TO F.FILE ELSE STOP : CLEARFILE F.FILE : : Mark Johnson : ----- Original Message ----- : From: "Stevenson, Charles" <[EMAIL PROTECTED]> : To: <u2-users@listserver.u2ug.org> : Sent: Saturday, October 01, 2005 3:33 PM : Subject: RE: [U2] Fw: More U2 programming hints : : : > yeahbut: basic's SSELECT does an alpha sort, even if keys are numeric. : > i.e.: 1,10,100,11,2 instead of 1,2,10,11,100. : > : > And the important gains for basic SELECT filevar over EXECUTE "SELECT : > filename..." are lost, (namely traversing the file only once), since the : > file needs to be entirely traversed to do the initial sort. : > : > cds : > : > > From: gerry-u2ug : > > in universe there is an sselect basic command : > > : > > -----Original Message----- : > > From: Larry Hiscock : > > : > > Mark Johnson wrote: : > > : > > > A: If opened and an A-Z select is desired, don't EXECUTE : > > > "SELECT FILE" : > > > then READNEXT, use SELECT. : > > : > > Only one problem: the internal select doesn't sort. It : > > returns records by their physical location in the file (ie by : > > group). So, until an intrinsic SSELECT verb is introduced to : > > basic, PERFORM "SSELECT ... " will continue to be used. : > ------- : > u2-users mailing list : > u2-users@listserver.u2ug.org : > To unsubscribe please visit http://listserver.u2ug.org/ : ------- : u2-users mailing list : u2-users@listserver.u2ug.org : To unsubscribe please visit http://listserver.u2ug.org/ : : ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
