>>>Did you add NOFILTER clause at the end? Did it speed up the process? How many records are in the table and how many satisfy the filter criteria?
>>
>>I suspect he's getting the equivalent of a SET FILTER. So there really is no data being transferred as would be the case with the NOFILTER. It's probably faster than with the NOFILTER.
>
>Yes, I suspect it too.
>
>What is VFP version? I don't recall did we have NOFILTER in VFP6? AFAIK we got it in VFP8.

I think he said VFP9 SP1.