ACCESS FEED: RE: [MS_AccessPros] database very slow on network

Minggu, 07 Juli 2019

RE: [MS_AccessPros] database very slow on network

It's difficult te jump in because it's an exclusion process. You start by checking the settings on both sides (type of cabling (Wifi??), speed settings, full/half duplex, auto negotiate going wrong, rx/tx-buffers settings, optimizations like jumbo packets/ packet size limitations like QoS), DHCP going wrong so traffic awaits time-outs all the time before choosing a secondary path or protocol, then protocol settings (unnecessary protocols like IPX/SPX, NetBEUI/NetBIOS, IPv6 or IPv4). Then address resolving slowness issues (Wins/Windows-DNS. Then traffic storms, faulty switches and network-cards, unconfigured devices on the network, detected/undetected wrong cable-configuring, then fileshare settings, self-referencing network paths in remote desktop, corrupted disk-i/o, overheated components trying to survive in not working cooling, cpu/memory load at both sides, corrupted/outdated malware stuff. It's complicated. The Northern Dutch Police took more than two months once with 80 man or so (but then again they were idiots).

Rob

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: vrijdag 5 juli 2019 23:05
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] database very slow on network

hi Sarah,

I see no one else has jumped in. This is not the right forum to be asking about network speed, although some here may happen to know ...

You didn't mention if you are on a local area network or wide area network. A consideration is how much RAM (random access memory) your machine has. Increasing RAM is one of the best things you can do to enhance machine performance, but the problem could be how you are cabled if local area network, the speed of switches and routers between your machine and the machine with the data, and type of cable. Video cards also have memory to process screen images, and this is another way to increase performance.

To see your machine specs:
From Access or any Office product, click "About [Product]" from File, Account, and then System Info...

Sorry I can't be more helpful.

have an awesome day,
crystal

On 7/4/2019 1:05 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:

The path is very short.

??I realize that local is faster, but the network is so slow, every screen takes a few minutes to load that?? I think it most be some setting on this network. I have installed on other networks and its fine.

Read something about 'Opportunistic locking in the windows file sharing layer ...', but its too technical for me.

Sarah

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

hi Sarah,

Local will always be faster. One thing you can do to enhance performance is to use a short path. Where is the drive physically located in relation to where you are? And do you know the path of the cables?

a couple suggestions to help performance:

Use short primary and foreign keys like AutoNumber/Long Integer as opposed to text fields with big Size

Build indexes on fields that are used for searching

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 7/3/2019 2:08 PM, sarahk@... [MS_Access_Professionals] wrote:

I just installed a new application: MS Access 2003, split. When I run it on a network drive it is extremely slow, but when I run the exact same application on the local drive it is very fast. I had to move the front and back end to the local drive, just moving the front end did not improve the performance. its a small db , less than 3MB for now.

What could be the reason?

All help is appreciated.

Thanks??

Sarah