I am building a windows form application that will be used all over the country with a central database residing in one location. All computers will be on same network, but I was wondering if I need to be concerned about latency in the time it takes to get to the database and back. Just wondering the best approach to access data. Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Access over network
- Thread starter mander23
- Start date
It will just be trial and error. There are several things you could look at -- if latency is an issue, and you have wide tables, try changing any SELECT * to return just the columns you need; don't return more rows than needed in your resultsets; on the other hand, reduce your number of calls to the database (which may actually result in more rows being returned per call) - for example, if you have a treeview/listview interface, LAN performance may be acceptable if you query for the ListView details on each node selection changed, but over the WAN, it may become slow and you may need to look at loading all of your data into memory first.
- Status
