OK then, I don't know if this will be faster, but I will give it a try:

select RecNo() AS RecNo, SortName from tmp1 where optimizedcondition;
  order by sortname into cursor tmp2 NOFILTER

This sould give a smaller cursor. Then:

SKIP 50000
lnRecNo = Tmp2.RecNo
select * from tmp1 where optimizedcondition;
  order by sortname into cursor tmp
GOTO lnRecNo

HTH

---

>Huh, and then I'll wait for end of this select since it will try to create another 100 meg file... That's possible if number of records selected is no more than 500.. So, the question is still in effect