>>No, John. It wasn't about indexing of remote view. The idea is that when you use SELECT-SQL (even rushmored) VFP requires part of CDX file travels through network, because processing is on workstation- this is the difference from client-server when server processes everything (including indexes) on spot.
>
>Yes, true. But if you grab the data through a remote view and do an index on the fly at the local workstation then you have the best of both worlds. Then again, if you use non-clustered indexes in SQL Server that put the data in the order you want maybe that *is* faster.
i.e. you mean that normal vfp-SQL-server approach is better. That's true. Actually, this thread was about the fact that imitation of client-server approach with still VFP database engine is slower than either traditional VFP system or traditional C/S system.
Edward Pikman
Independent Consultant