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.
"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