>Hi guys ---
>
>>>>1) Using SQL Server as the data engine will perform 3 to 5 times faster than VFP and there's nothing you can do about it.
>>>
>>>Disagreed, because VFP-performance will be
>>>a) specific to each workstation hardware
>>>b) depends on interface arrangements. Assuming that you compare with SQL-server, i.e. just one/few records will be 'retrieved' by interface at a time, then SEEK() will be probably even faster.
>>
>>But SEEK() in and of itself is totally not client/server.
>
>Why is SEEK() not client/server? Client/server is simply a topology. If everything is remoter views and you index a remote view, SEEK away. Doesn't mean it's not client/server.
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.
Edward Pikman
Independent Consultant