Access speed on network, network part evaluation?

[Philip Leduc]

When you build a mulituser applicatin on a network, one component of your
speed is the way the database is build, and I do know some tips and tricks
to handle improve the database as much as possible.
On the other hand, does anybody know how to argue about the network speed
(measure it, how to improve it) as part of the speed equasion? How can you
prove that bad network speed causes unneccesary delay?

Philip

 

[Van T. Dinh]

To do it properly, I think you need some specialised hardware to monitor the
network traffic ...

 

[Bill Mosca, MS Access MVP]

One of the best ways to improve speed over a network is to put the backend
in a folder as close to the root directory as possible. The deeper it is,
the longer it will take to establish a connection from the front end.

 

[Albert D. Kallal]

How can you prove that bad network speed causes unneccesary delay?Well, I guess the key word in the above is "unnecessary".

I mean, a slower network is slower!!!

Hum, how can you prove that driving slow in a car makes the trip longer?
This is essentially the same question. I not sure exactly how you show that
driving slower makes the trip longer, but for most people, it is simply a
obvious, and demonstrable truth.

So, how do you prove that 2 + 2 = 4?, you demonstrate it with examples

So, how do you prove that driving a car around a oval track slower takes
longer?, you demonstrate it with a stop watch, and examples, and some math.

Simply try coping a file on a computer network that is a 10 baseT network.
Now, try a network with better speed, and the file will copy faster.

I also speak speed of network speed here:

Using a wan with ms-access? How fast, how far
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

Simply put, a slower network = slower data transfer = worse performance.

the only part that is hard to define is "unecessary"

 

[John Vinson]

When you build a mulituser applicatin on a network, one component of your
speed is the way the database is build, and I do know some tips and tricks
to handle improve the database as much as possible.
On the other hand, does anybody know how to argue about the network speed
(measure it, how to improve it) as part of the speed equasion? How can you
prove that bad network speed causes unneccesary delay?

Philip

Check out the suggestions on Tony Toews' website
http://www.granite.ab.ca/access. He has detailed pages on both
performance and networking issues, with both his own experience and
links to Microsoft and other sites. Well worth study!

John W. Vinson[MVP]

 

[aaron.kempf]

using MDB across a network is not a reccomended architecture.

MDB isn't a true client-server environment. it is inefficient;
unstable; unreliable.

Spit on anyone that uses MDB for anything


-Aaron