There are key differences between the two types of selects. The EXECUTE "SELECT..." guarantees you access all the records that fit your criteria at the moment of the execute. The BASIC SELECT processes node by node of the datafile which allows for the possibility of records being added, deleted, or even just plain skipped in the case of a group move of a dynamic file, between the start of your program execution and the end of its execution. Granted, most of the time it's a non-issue because the time involved is pretty small. As long as you're aware of this difference and don't blindly think the two selects are identical in execution, then you should be okay.
Also, I'd agree with the statement that the BASIC SELECT is faster... TO PROCESS THE FIRST TRANSACTION. But for the total execution time of any given run of the whole process, I think you'll find it's pretty darn close with only a slight difference. BobW -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, October 25, 2011 2:14 PM To: U2 Users List Subject: Re: [U2] UniBasic Question >> Unless you know the keys to the records you're selecting, even the >> EXECUTE "SELECT ..." is going to have to read each record, how else >> would it know which records to throw out? SELECT is definitely faster than EXECUTE "SELECT..." and I try and use it first. Charles Shaffer Senior Analyst NTN-Bower Corporation _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
