We are maiking a windows application using dotnet.this is based on a centralized database server.
We are implementing this application in a state. The database server will be located at one central position.
Clients will be far apart from the database Server..
There may be a distance of 20-30 Kms between these locations and database server..
We are using Sql server2000 as database server.
we are using stored procedures and disconnected approach in ado.net
So my question is:
What type of connectivity media should be used?
will database performance be depenedent on the connectivity media?