SQL-Server will be slower, because you have to 'fetch' the data for every record (or record set) displayed. With a DBF you have a direct link to all the data, so painting the screen is very fast, even with a large grid.
As for data access, my opinion is to use Remote Views if you are going to UPDATE the data and SQL Pass Through anywhere the data is static - as in lookup lists in combos, etc. I have a small app I'm working on that works this way - only three parameterized views and a LOT of SQL Pass Through using a single handle. I store the handle value in a form property and call it repeatedly, leaving it open while the form is open. The way the app will be used, this won't overload their SQL-Server.
HTH
Barbara
>Now we are trying to use MS-SQL server as a backend for our VFP front end application. Any comments on performance of MS-SQL Server Vs. VFP ?
>
>Also I wish to know if we are going to access a remote data source such as MS-SQL server or Oracle which one of the following is the best way to accomplish that:
>
>1) SQL Pass through
>2) Remote SQL Views
>3) ADO Recordset -> DBF and vice versa.
>
>I have read the MSDN foxpro chapters about (1) and (2) and foxtalk articles April/May 1999 by Jim Falino, but still I couldn't be able to decide. Any help would be appreciated.