[dba-Tech] Access Performance on a WAN

Dan,

Latency is the amount of time it takes for a data packet (i.e., a unit of
data) to move across a network connection.  Latency and bandwidth are the
two factors that determine the speed of your connection.

An example is with a hard drive, latency in this respect is the time between
requesting the data form the HD and the actual transfer starting.

One of our clients wanted to do some stuff over a slow WAN that had network
problems.  I told them that we would not support it.  I had a MS KB article
that talked about it, but I cannot locate it at this time.

With the speed of that WAN, you may not have problems.  And since they are
willing to test first...

Bobby

Bobby

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, March 07, 2005 1:55 PM
To: 'Discussion of Hardware and Software issues'
Subject: RE: [dba-Tech] Access Performance on a WAN


Bobby - what is latency?

And it will be agreed to by me and my customer before we start.  They said
they can set up a test to simulate typical activities to see how it goes.

Dan

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Monday, March 07, 2005 12:19 PM
To: 'Discussion of Hardware and Software issues'
Subject: RE: [dba-Tech] Access Performance on a WAN

>From my understanding, you will do this at your own risk.  The speed is 
>not
the issue, it is the latency.

Some people have implemented this without any problems, but I have read of
others with lots of corruption and the like.

Bobby

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, March 07, 2005 12:52 PM
To: 'Discussion of Hardware and Software issues'
Subject: [dba-Tech] Access Performance on a WAN


Hello to Everyone!

 

I have a potential customer with a few different sites around the country.
They have a WAN with 1.5 Gbit/sec capacity.  I said that I would like to do
a test to see if this is feasible with Access XP, and they are willing to do
that.  I can do a few things to minimize network traffic to help things work
faster, but a test is still needed.  I do use a split FE/BE setup.

 

Does anyone have experience with this scenario?

 

Does 1.5 Gbit/sec correspond to 1.5 / 8 = 187.5 Mbytes/sec?

 

Thanks!

Dan Waters

ProMation Systems