What is not a fair comparison is that an app of any sort never does a "Select *" in the Query Analyzer. I don't want to speak for JVP, but you're missing a couple points here:

1) You have to forget "Select *" even exists (for the most part) when dealing with client/server. Any application will limit the recordset returned in some fashion.

2) You don't ever use SQL Server to do the processing. I.E. you don't have apps that run in the Query Analyzer. So anything you do in the Analyzer is not a test of application performance. Modify an app that deals with local DBFs to use Remote Views or SPT. Then benchmark performance.

There are other principles that I can't think of, off the top of my head. But basically the goal is to not only increase performance of your app, but of the entire WAN. Minimize the data traversing the wire.

PF
>So, just for grins, I opened a VFP table in the VIEW window and issued select * in the command window and the results came back instantaneously. I did the same thing in the Query Analyzer and it took noticeably longer, but it was still very fast. If this is not a fair comparison, then I stand corrected and I'm the biggest turkey in the world.