>Try the following:
>
>local i
>select *, inc(@i) as rec_no from tmp1 where optimizedcondition;
> order by sortname into cursor tmp
>index on rec_no tag rec_no
>seek 50000
It seems like everything that I've tried causes two behaviors:
1. Slow select (with Nofilter or like code above)but fast skipping in resulting cursor
2. Fast select (without nofilter) but Slow skipping.
Also, i've noticed that the more records is under filter the faster is the skipping...
Huh, damn problem
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer