Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / March 2006

Tip: Looking for answers? Try searching our database.

shared over network - mapped drive vs. sharename

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jesper F - 22 Mar 2006 18:11 GMT
Which is faster, if any, when accessing a backend from a local fronted over
a network -
mapping the share to a driveletter og just using the sharename?
Does it matter?

Jesper
Albert D.Kallal - 22 Mar 2006 19:37 GMT
I am not aware of any performance differences.

There has been a few comments that performance can be hurt if the path name
is very deep and long.

However, you are MUCH better to use a share name, as drive letters can
change, have to be setup in the first place, and are generally a pain in the
neck.

Drive letters go back 20 years ago to dos and cpm days...you would do well
to avoid them.....

Signature

Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Jesper F - 22 Mar 2006 22:02 GMT
> There has been a few comments that performance can be hurt if the path
> name is very deep and long.
>
> However, you are MUCH better to use a share name, as drive letters can
> change, have to be setup in the first place, and are generally a pain in
> the neck.

Ok, thanks. I'm sticking with them.

Jesper
Douglas J. Steele - 22 Mar 2006 23:15 GMT
> However, you are MUCH better to use a share name, as drive letters can
> change, have to be setup in the first place, and are generally a pain in
> the neck.
>
> Drive letters go back 20 years ago to dos and cpm days...you would do well
> to avoid them.....

Interesting comment, Albert. Afraid I don't agree with you.

As you know, I work for a multinational corporation. We have the same
application in use in multiple locations. Our applications are always on the
J: drive, where users only have Read access. The databases are always on the
I: drive, where permissions are set appropriate to the need. (Drive mapping
happens as part of the logon process). If we were to use UNC's, we'd have to
have a separate installation package for each location, something that's
just unimaginable in our environment.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Tony Toews - 30 Mar 2006 03:52 GMT
>However, you are MUCH better to use a share name, as drive letters can
>change, have to be setup in the first place, and are generally a pain in the
>neck.

I can see both sides of this debate.  For me for one client drive
letters were great.  I could SUBST Z: to folder on my system for
testing.  And then map the drive letter to the server share to access
the live system.

Also if you change server names well, you've got the same problem.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

david@epsomdotcomdotau - 30 Mar 2006 00:11 GMT
Once you have a connection, it will be cached by your local
network client.

People sometimes set their pc's to connect to mapped drives
at startup. If you have done that, then the connection will
already be cached.

Depending on how your shares are set up, the cached connection
to a share may time out when it is not being used.

In contrast, mapped drives get refreshed all the time, one
way or another. (Sometimes you can see this slowing down
work you are doing at the computer)

But mapped drives are likely to be 'faster' only if your network
is really badly managed and your application is incorrectly
designed.

If the time taken to make a connection is bigger than the
time taken to do security checks, lock data, and retrieve,
then your network is not set up correctly.

A stupid 'optimisation' to the Jet 3.0 engine,  means that there
is a lot of overhead in connecting to a Jet database. For this
reason, you need to maintain a persistent connection to your
database. If you are maintaining a persistent data connection,
your cached network connection will never be lost, and you
only ever have to find the share at application start up.

An advantage of mapped drives is that they can be redirected
to other shares.

An advantage of shares is that they don't get re-directed when
the mapped drives change.

For these reasons, mapped drives are often the choice of formal,
very large organisations.

And network shares are often a better choice for informal, small
or medium organisations.

(david)

> Which is faster, if any, when accessing a backend from a local fronted over
> a network -
> mapping the share to a driveletter og just using the sharename?
> Does it matter?
>
> Jesper
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.