Here's my results running on a VAIO N505

Mark Young

Locate: 0.97 seconds vs. Seek: 0.25 seconds.
Locate: 0.94 seconds vs. Seek: 0.25 seconds.
Locate: 0.94 seconds vs. Seek: 0.25 seconds.
Locate: 0.94 seconds vs. Seek: 0.26 seconds.
Locate: 0.98 seconds vs. Seek: 0.26 seconds.
Locate: 0.94 seconds vs. Seek: 0.26 seconds.
Locate: 0.93 seconds vs. Seek: 0.25 seconds.
Locate: 0.94 seconds vs. Seek: 0.25 seconds.
Locate: 0.94 seconds vs. Seek: 0.25 seconds.
Locate: 0.99 seconds vs. Seek: 0.25 seconds.


>Brien,
>
>These are my results:
>Locate: 1.00 seconds vs. Seek: 0.24 seconds.
>Locate: 1.00 seconds vs. Seek: 0.25 seconds.
>Locate: 1.00 seconds vs. Seek: 0.24 seconds.
>Locate: 0.99 seconds vs. Seek: 0.24 seconds.
>Locate: 0.99 seconds vs. Seek: 0.24 seconds.
>Locate: 0.99 seconds vs. Seek: 0.24 seconds.
>Locate: 0.99 seconds vs. Seek: 0.24 seconds.
>Locate: 0.99 seconds vs. Seek: 0.24 seconds.
>Locate: 0.99 seconds vs. Seek: 0.24 seconds.
>Locate: 0.99 seconds vs. Seek: 0.24 seconds.



>>>George
>>
>>Locate: 4.02 seconds vs. Seek: 3.90 seconds.
>>Locate: 3.97 seconds vs. Seek: 3.90 seconds.
>>Locate: 3.98 seconds vs. Seek: 3.91 seconds.
>>Locate: 3.97 seconds vs. Seek: 3.90 seconds.
>>Locate: 3.97 seconds vs. Seek: 3.97 seconds.
>>Locate: 4.16 seconds vs. Seek: 4.25 seconds.
>>Locate: 4.35 seconds vs. Seek: 4.24 seconds.
>>Locate: 4.32 seconds vs. Seek: 4.24 seconds.
>>Locate: 4.35 seconds vs. Seek: 4.11 seconds.
>>Locate: 3.98 seconds vs. Seek: 3.90 seconds.
>>
>>
>>Anyone else want to test the code?
>>
>>

>>LOCAL lnFile, lnI, lnJ, lnLocate, lnSeek, lnTime
>>
>>IF !USED("Test")
>>  CREATE CURSOR Test (pID i)
>>  INDEX ON pID TAG pID
>>  FOR lnI = 1 TO 1000
>>    INSERT INTO Test VALUE (lnI)
>>  ENDFOR
>>ENDIF
>>
>>lnFile = FCREATE("TestResults.txt")
>>FOR lnI = 1 TO 10
>>  SET ORDER TO
>>  lnTime = SECONDS()
>>  FOR lnJ = 1 TO 10000
>>    LOCATE FOR pID = 699
>>  ENDFOR
>>  lnLocate = SECONDS() - lnTime
>>
>>  SET ORDER TO pID
>>  lnTime = SECONDS()
>>  FOR lnJ = 1 TO 10000
>>    SET ORDER TO pID
>>    SEEK(699)
>>    SET ORDER TO
>>  ENDFOR
>>  lnSeek = SECONDS() - lnTime
>>  FPUTS(lnFile,"Locate: " + ALLT(STR(ROUND(lnLocate,2),10,2)) + ;
>>    " seconds vs. Seek: " + ALLT(STR(ROUND(lnSeek,2),10,2)) + " seconds.")
>>ENDFOR
>>FCLOSE(lnFile)
>>
>>MODI FILE TestResults.txt
>>

>