>Hilmar
>
>You might be interested in the following comparison
>
>The database being scanned has 50 fields so records sizes are quite large
>approx 59000 records
>
>The following code took 18 seconds
>
>select globalnew
>set order to tag created
>go top
>scan for accountno=accountno
>endscan
Apart from the caching issue: Did you SCAN FOR .T. on purpose?
What I would find more realistic is to work on a subset of the data, as follows:
select globalnew
set order to "created"
seek lnAccountNo
scan while accountno = lnAccountNo
endscan
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)