Snip..
>>You're right but "go top" with a filter is so slow. Use locate instead.
>>cetin
>You could be right about that. I ran some tests(100 reps of each) on a 400K record table. I haven't had time to really go thru the figures but it looks like on a random filter set on a EXCLU open the goto ran a little faster. With the same test on a SHARE open the locate ran faster(but both took about twice the time as the EXCLU open). I'll run the 'NO RECORDS' filter later - they take about 3 minutes to run 10 tests(about 12 times the random filter shared) and I want to do 100 tests on each type open. I'll let you know what I find out.
Sammie,
To cut down the tests a little, add a dummy index tag for deleted or nondeleted(index on !deleted() tag dummy) and delete a lot. Run the test with fully, partially optimizable expressions. I already tested them for years and it's the pros not only me, indicating to the importance of speed with locate vs gotop-gobottom. Also try this :
set order to tag anytag
goto 200000
go top
go bottom
set order to tag anytag
goto 200000
locate
set order to tag anytag descending
locate
set order to tag anytag
Cetin