Network traffic jumps to 50% when opening a 2nd front-end mdb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing non-stop data processing in one .mdb reading different tables and
writing into one. All tables are linked to my back-end.

If I just open a second mdb front-end with the same linked tables, the
network traffic jumps from 1 to 50%.

Any explanations for this behavior ?
 
Windows 'opportunistically upgrades shared locks to
exclusive locks if there is only one user of a file.

Exclusive locks require less network traffic. Also,
if the file is exclusively locked, it is cached at
the workstation, so less network traffic is required.

Conversely, if a shared lock is required, the cached
copy of the file must be copied back to the server,
which creates a short traffic spike.

You can turn off Opportunistic locking to see if it
is the cause of the network behaviour you are seeing.

(david)
 
Back
Top