PC Review


Reply
Thread Tools Rate Thread

Access speed on network, network part evaluation?

 
 
Philip Leduc
Guest
Posts: n/a
 
      16th Oct 2006
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


 
Reply With Quote
 
 
 
 
Van T. Dinh
Guest
Posts: n/a
 
      16th Oct 2006
To do it properly, I think you need some specialised hardware to monitor the
network traffic ...

--
HTH
Van T. Dinh
MVP (Access)




"Philip Leduc" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
 
Bill Mosca, MS Access MVP
Guest
Posts: n/a
 
      16th Oct 2006
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.

--
Bill Mosca, MS Access MVP


"Philip Leduc" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
 
Albert D. Kallal
Guest
Posts: n/a
 
      16th Oct 2006
> 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"

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)


 
Reply With Quote
 
John Vinson
Guest
Posts: n/a
 
      16th Oct 2006
On Mon, 16 Oct 2006 10:14:38 -0400, "Philip Leduc"
<(E-Mail Removed)> wrote:

>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]
 
Reply With Quote
 
aaron.kempf@gmail.com
Guest
Posts: n/a
 
      17th Oct 2006
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


Philip Leduc wrote:
> 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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost access to part of network Malin_forme Windows XP Networking 3 11th Dec 2008 05:11 PM
ACCESS NETWORK SPEED =?Utf-8?B?QW5kcmV3REI=?= Microsoft Access 3 27th Sep 2007 10:51 AM
Speed of a network Access database =?Utf-8?B?QWx5bGlh?= Microsoft Access 7 24th May 2006 03:13 AM
Re: Will a gigibit network improve MS Access speed across network? Tony Toews Microsoft Access 0 7th Feb 2004 03:02 AM
Re: Will a gigibit network improve MS Access speed across network? Arvin Meyer Microsoft Access 0 7th Feb 2004 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:35 PM.