Flame war? There is no such thing here:).
However, you are really get some misunderstanding. Foxpro never claims whole table to local machine (surely, if you have Rushmore-optimizable SQL expressions), and only retrieved recordset will travel over network.

>Maybe I'm misunderstanding here (not trying to start a flame war! <grin>):
>
>I think that if you have a huge table/database and you're actually wanting a result set that's fairly small, then SQL Server would be the best approach since the entire table doesn't have to come down the network wire and be operated on by your local machine (the operation can be performed on the Server, which you've "beefed up" in memory, processor, etc. just for that kind of operation).
>
>If you're querying a fairly small table, then using VFP alone will be faster because your machine can perform the operation directly (yeah Rushmore!) and you won't have the overhead of establishing the SQL connection and all of that handshaking.
>
>If I'm wrong - let me know!
>
> Kevin
>
>
>I have to disagree with you here. VFP will be always faster than SQL-server on light traffic (doesn't matter how big your vehicle-recordset is) and slows down on busy traffic with many cars (users changing data).
>Once again, hundreds of thousands of records is not a limitation.
>
>>Kevin,
>>
>> How big are your inventory files? If it's a few thousand records, SQL Server *is* probably overkill; if you're doing queries on hundreds of thousands of records (and returning result sets of, say, a few hundred records) then it's probably your best approach.
>>
>> Kevin E. Stroud
>>
>>
>>
>>Right now we have some VB apps that use SQL 6.5 on the back end. We have about 20 active users. most of them doing simple inquires into inventory available for instance. I dont believe we have a busy system. The software seller tells me that SQL 6.5 is overkill.