Charlie...

Like Christof said... in reality, you either opened the whole table again, or a filtered result set in VFP.

Tell you what, get on a WAN, with a 500,000 - 1,000,000 row table. Run a query in VFP and run the same thing with SQL. Then tell me which one is faster....

As for scrolling recordsets, we are talking about a client-server scenario. You don't return every row in a table....


Keep in mind what I am about to say should not be construed as a personal attack....

My guess is that your perception of what did as being a valid test indicates that you know little to nothing with regard to how SQL-Server works, and in additon, know little to nothing with integrating VFP and SQL Server....

If I am wrong, my sincerest appoligies. The critieria that you have placed before me however, indicates otherwise.....



>I just ran a simple select * query in the Query Analyzer. It reported an execution time of 00:00:04. I ran the same query in VFP and it was so fast it wouldn't even register on the clock. You really don't need the clock at all to tell which is faster. VFP is so fast that the results are in face your instantly. In SQL Server you can actually see the clock counting.
>
>Then try to scroll through the result sets. VFP moves so fast the gird lines are a blur, in SQL Server it moves much slower, and if you move the scroll bar too far you can overload it and it will jump back.
>
>My machine is a pentium 550 with 250 RAM.
>
>Charlie