[dba-Tech] Access Performance on a WAN

Dan,

Here are some other considerations when running over a LAN.

How big is the database?  Irrespective of where the FE is stored, all
processing takes place on the local PC.  Inquiries of large amounts of data
could result in massive amounts of data being passed over the connection to
be processed locally.

How is the application structured?  Does it use bound forms or unbound
forms?

If there are multiple locations accessing the database simultaneously, do
they each have a 1.5Gb upload pipe to the file server?  Does the file server
have a 1.5 Gb download pipe to each location, or will all locations be
sharing the 1.5Gb line?

Running a test should give you an indication of potential problem areas.  If
there are problems, here are 2 solutions.

1. Convert the FE to an ASP application and run it over a web connection.

2. Host both the FE and BE in a Terminal Server environment.  If your
customer does not have this capability, there are commercial services that
only charge about $30 per month per location.

Joe O'Connell

-----Original Message-----
From: Dan Waters <dwaters at usinternet.com>
To: 'Discussion of Hardware and Software issues'
<dba-tech at databaseadvisors.com>
Date: Monday, March 07, 2005 1:56 PM
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
|
|_______________________________________________
|dba-Tech mailing list
|dba-Tech at databaseadvisors.com
|http://databaseadvisors.com/mailman/listinfo/dba-tech
|Website: http://www.databaseadvisors.com
|
|_______________________________________________
|dba-Tech mailing list
|dba-Tech at databaseadvisors.com
|http://databaseadvisors.com/mailman/listinfo/dba-tech
|Website: http://www.databaseadvisors.com