RE: [U2] relative speed of Retrieve SELECT vs Basic SELECT, LOOP READNEXT,READ. was: [UV] WHILE READNEXT id DO

> Looks like someone has too much time on their hands today Actually, the question grows out of a real need for a phantom to repeatedly loop through a file all day long. My problem is that the phantom does not have "too much time". I thought the repeated overhead associated with executing a SELE

Re: [U2] relative speed of Retrieve SELECT vs Basic SELECT, LOOP READNEXT,READ. was: [UV] WHILE READNEXT id DO

Looks like someone has too much time on their hands today "Stevenson, Charles" <[EMAIL PROTECTED]> wrote:Please let me deflect this thread before it degenerates into a GOTO war. Which would you suppose is much faster: 1: T0=TIME() FOR I = 1 TO 100 EXECUTE 'SELECT VOC WITH TYPE = "V" COUNT.SUP'

Re: [U2] relative speed of Retrieve SELECT vs Basic SELECT, LOOP READNEXT,READ. was: [UV] WHILE READNEXT id DO

At 02:16 PM 6/17/2004, you wrote: [snipped] Note: SELECT F is a BASIC select, not Retrieve's (not the MV Query Language's) verb. It does not really select the file, it merely sets up for the subsequent READNEXTs to truly read the next key. So READNEXT ID;READ REC FROM F, ID involve going to the

RE: [U2] relative speed of Retrieve SELECT vs Basic SELECT, LOOP READNEXT,READ. was: [UV] WHILE READNEXT id DO

rsday, June 17, 2004 11:16 AM To: [EMAIL PROTECTED] Subject: [U2] relative speed of Retrieve SELECT vs Basic SELECT, LOOP READNEXT,READ. was: [UV] WHILE READNEXT id DO Please let me deflect this thread before it degenerates into a GOTO war. Which would you suppose is much faster: 1: T0=TIME()

[U2] relative speed of Retrieve SELECT vs Basic SELECT, LOOP READNEXT,READ. was: [UV] WHILE READNEXT id DO

Please let me deflect this thread before it degenerates into a GOTO war. Which would you suppose is much faster: 1: T0=TIME() FOR I = 1 TO 100 EXECUTE 'SELECT VOC WITH TYPE = "V" COUNT.SUP' LOOP WHILE READNEXT ID NULL ;* GOSUB DO.STUFF REPEAT