>>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.

Ahhh...yes it is. I find myself gaining more respect for server side indexes, though.