>>As you see, all what I want is plain cursor which I can browse or whatever but instead I'm getting filtered tmp1 table where skip 50000 command causes indefinite lockup < g >
>Vladimir,
>How large your table? Did you try index it and then skip 50000?
>I had similar app (250,000 rec , SKIP 40000) SKIP took about 1 min on P350. Still slow but was acceptable.
>And I tried SCAN NEXT...ENDSCAN , but it took about 2 min.
My current table I test on is 55000 records (40 Meg in size) but production table can easily go up to 0ne million records. I tried the Skip 50000 on my P210 with 32 Mb Ram and it took around 20 minutes, can't imagine what will happens if the will be one million records
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer