>>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
Thank you, Cetin.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham