I wouldn't expect any slowdown on such small tables unless any of them have big text/image fields or SQL Server/Network is slow.
>
>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.
--sb--