>Hi,
>
>As I am converting an application from VFP database to SQL Server, I came across the following question.
>
>I was wondering if someone can give me an estimate of time I should expect to open a form that pulls 3 tables from SQL Server. The average size of the tables are about 30, 200, 1000 rows/records. On my PC where I develop the application and have SQL Server installed everything is very fast. But in a real production situation, the SQL Server will most likely be on a different box and the time to retrieve the records will be greater. What I am trying to find out is to what extend will the time increase.
>
>Thank you in advance for any input.
With a C/S application you shouldn't be getting all the data but only what you need so it would be fast. Otherwise you can check client statistics on your local installation and make a guess on the time it takes to transfer that much data on a network.
Cetin