>SNIP
>>
>>When you run select from command window you probably create filtered 'cursor'. Try to issue it with NOFILTER and you will see the difference. Also, what about SET DELETED setting and TAG on DELETED()?
>>Again, there is no reason to use Remote or Local views returning thoousands of records. The whole idea of view is to return few records.
>
>Edward,
>
>Jut because the book states that a NOFILTER can slow things down does not mean that it will *always* slow things down. A 1 - xxxx result set should show only an imperceptible difference in timing.

I just meant that view will always simulate NOFILTER, so the 'fair' comparison would require to include it from command window.

>Also, I think he says he uses ODBC because he does not trust that VFP will live beyond version 6. To that I would say:
>1) we are told that a version 7 is under development (though it is true that nothing says it *will* be released);
>2) Version 6 should continue to operate correctly for years to come (I think that FPD/FPW 2.6 proves this)

Agreed, and anyway it is not applicable to this choice, or the thinking is that VFP disappears and VFP ODBC driver not? :-).