>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
View is essentially SELECT-SQL with NOFILTER clause, this is the reason why plain SELECT_SQL (without NOFILTER) gave your better time. NOFILTER clause is mandatory if you plan to do something with the recordset you retrieved from table. For example, if you want to show it in grid/update/save back to table, basically do anything except just looking at it by BROWSE launched from Command Window: all these operation will force you to use NOFILTERed cursor/view.
Edward Pikman
Independent Consultant