Re: Bandwidth Issues.

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 01/22/05 

Date: Fri, 21 Jan 2005 18:37:39 -0800

First, XML is about as heavy as you can get.
I've run client/server applications over a 2400 baud (that's 2.4K) modem
from Dallas to Redmond over a dialup connection and tested the throughput.
It was about 20% less than a LAN connection which in those days was less
than 1M baud). As I discussed in my early books, the trick is to ask for
what you need and no more. With client/server you send a small (few hundred
bytes) of SQL and overhead to return a few thousand bytes of
results--assuming you aren't asking for the contents of the customers table
over the wire. Unlike Access/JET that does physical IO over the LAN (or
WAN), SQL Server is designed for this kind of application. If you're using
JET/Access, you're pooched. It has a number of serious issues when used over
unstable IO links. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Sam Davis" <SamDavis@discussions.microsoft.com> wrote in message 
news:88BB841F-F188-459C-BEF4-F40A65A9CB5E@microsoft.com...
>I was wondering if anyone out here has any words of advice when it comes to
> running a client/server application where bandwidth concerns are present.
> Such as running a thick client deployment over a dial-up connection or
> telecommunications that aren't at network speeds. I would be curious to 
> here
> your thoughts on how to improve performance between the application and 
> the
> server. This is a sql server deployment. Is XML lighter than ADO or even
> ADO.NET?
>
> Thanks to anyone who responds!

Relevant Pages

  • Re: Service Question
    ... A webservice uses the web to send and retrieve information ... using XML and is therefore easy to use everywhere. ... It is the ultimate ... client/server application and it can use itself a windowservice that ...
    (microsoft.public.dotnet.languages.vb)
  • Re: THREE EXCELLENT QA ANALYSTS AVAILABLE
    ... client/server applications on UNIX, WindowsNT/2000/2003 and Windows XP ... QuickTest Professional, Rational Products like Rational/SQA Robot, ... Sybase, Oracle 7/8i, DB2, MS Access, SQL Server 6.5/7.0 ... unit testing in different stages of Software Development Life Cycle ...
    (comp.databases.informix)
  • Re: THREE EXCELLENT QA ANALYSTS AVAILABLE
    ... client/server applications on UNIX, WindowsNT/2000/2003 and Windows XP ... QuickTest Professional, Rational Products like Rational/SQA Robot, ... Sybase, Oracle 7/8i, DB2, MS Access, SQL Server 6.5/7.0 ... unit testing in different stages of Software Development Life Cycle ...
    (comp.databases.informix)
  • Client / server data retrieval
    ... the Server is SQL SERVER 2000. ... This works great when using UDF procedures to do the encrypting/decrypting. ... the MS-ACCESS client using SQL via an ODBC connection. ... transfer between the Client/Server is achieved using a Linked Database. ...
    (microsoft.public.sqlserver.clients)
  • Re: remote server
    ... client/server. ... Unfortunately, I can't use VPN. ... > when it comes to working with a SQL server. ... >>> what is the best way connect to remote SQL server. ...
    (microsoft.public.dotnet.framework.adonet)