Don't forget that repeated tests may use previously cached indexes and appear to be faster than the initial run.

Closing out of FoxPro clears out the cached indexes for testing purposes.


>Hi,
> Is view slower than SQL statement and SET FILTER TO command while query records?
> I tried to query my table from DE 1,000,000 records with this 3 methods. I found that, SQL statement and SET Filter to just take 1 second <>, but my view take about 44 seconds... why? how to solve it? Will it happen to newwork mode too?
>
>Thank you