>>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.
If it's not broken, fix it until it is.
My Blog