[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Which technology to be used LeasedLine,Broadband,ISDN

Posted on 2006-04-13
Medium Priority
Last Modified: 2013-12-29
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.

So my question is:
 What type of connectivity media should be used?
Question by:harpreetkhurana
  • 2
LVL 27

Accepted Solution

pseudocyber earned 500 total points
ID: 16444288
"These days" many dispersed networks and users are relying on VPN's over their broadband Internet connection.

Usually developers don't care about the physical media used to make a connection.  However, it might be wise planning on higher latency if you know your users are remote.

I'm not a developer - but it's my understanding that for remote data base use the main thing is to properly develop a true client-server database model so that table sizes which traverse the connection between client and server are minimized and most processing is done on the server.

You might want to ask this question in a programmer or data base forum.
LVL 12

Expert Comment

ID: 16444981
ISDN: It Still Does Nothing.
Broadband: often asymmetric, and that can lead to bursts of high latency.
Leased Line: you get what you pay for.
LVL 14

Assisted Solution

ECNSSMT earned 500 total points
ID: 16446029
pseudocyber just reminded me of an epic struggle between network and database people.  Doing a big SQL query between client and server takes up a lot of bandwidth.  Network people don't like that;it boggs everything down.  Also not a big issue, large numbers of open database sessions (its not one connection per user, its one connection per table that is opened by the user; the occassional ACKs (I don't know the actual database termonology) to keep those connections active can be an issue for database people.  If the line hiccups; those sessions are lost and depending on the resilency of the database engine; there could be corruptions.

Depending on what you need, like if you are going to a site with multiple users, it may be recommendable to go with some sort of leased line technology, but it will cost.  If its indivuals, well anything you can get your hands on.  In terms of developing, I do hope you take the above into consideration and put a front end on and not have the users do queries from their workstations and instead permit the frontend servers to do the actual queries.

LVL 27

Expert Comment

ID: 16446078
ECNSSMT's comment is exactly what I'm talking about.  Over a comparatively "high speed" LAN - 100Mb full duplex - it's not so much of an issue.  But over a WAN or Dial up/VPN connection, it can quickly become a major issue/deal breaker.

Featured Post

Enhanced Intelligibility Without Cable Clutter

Challenge: The ESA office in Brussels wanted a reliable audio conference system for video conferences. Their requirement - No participant must be left out from the conference and the audio quality must not be compromised.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question