Hi Frank,

I can't give you any published metrics but I can advise that Fox runs just fine against SQL server, irrespective of the size of the server side tables. As always, it boils down to a few things, the queries against SQL server (in the form of your remote views or SQL passthru) should be restricted to bring back only the maximum number of records that satisfy the query. So, your queries should only return the data you actually need - nothing more, nothing less. Also, if the SQL server in question is badly tuned, VFP will be limited by the speed of the SQL server in question responding to the query it is asked to execute.

If you create the query you want to execute on the SQL server itself and it responds as quickly as you would expect it to, then you should be in good shape when VFP executes the query (via the remote view or SQL passthru) from the client side.

HTH

Regards,


>Hello,
>
>Has anyone worked with VFP against large SQL Server tables ( 200+ million records , 100 GB .mdf file size ).
>
>I would appreciate any metrics that might be out there in terms of running SQL statements from VFP to get a recordset which can then be used inside of VFP for analysis, etc. or processed record by record.
>
>Thanks.