[AccessD] Speed Issues on network just with Access App

[Gustav Brock]

Hi John

At Wikipedia:

    https://en.wikipedia.org/wiki/Microsoft_Access

I noticed this:

<quote>
In July 2011, Microsoft acknowledged an intermittent query performance problem with all versions of Access and Windows 7 and Windows Server 2008 R2 due to the nature of resource management being vastly different in newer operating systems.[35] This issue severely affects query performance on both Access 2003 and earlier with the Jet Database Engine code, as well as Access 2007 and later with the Access Database Engine (ACE).[35] Microsoft has issued hotfixes KB2553029 for Access 2007 and KB2553116 for Access 2010, but will not fix the issue with Jet 4.0 as it is out of mainstream support.[35]
</quote>

The reference 35 is here:

    http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/86e59bc0-3524-45be-89d0-3528cfea842b

If that is so (the last sentence), it may be the full explanation for your trouble - and you seem to be hosed.

/gustav


-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 7. november 2016 17:44
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Speed Issues on network just with Access App

Hi John and Darryl

In my experience, Windows Update has been vastly improved from Win7 to Win8.x and indeed to Win10.
It now runs smoothly in the background.

Also, it can be adjusted to your liking in the Enterprise version; the Home edition is not that flexible.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af James Button
Sendt: 7. november 2016 17:27
Til: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Speed Issues on network just with Access App

Darryl, (and anybody else interested)

Re slowdown in win-10 

I noted that:
Soon after win-10 came to our PC's the win-7 update process got very slow And - for PC's with less than 1GB memory the update went from a few minutes - maybe up to 30 for a check of what to get, to several hours, maybe a day.
That can be helped by turning off ALL concurrently running processes - including performance monitor, and anti-virus checking.
The new update process seemed to want to read all of the files on the OS partition.

I used the profile facility in 10-pro to set it to ask about updates - and when that constraint seemed to get turned off by a fix, turned it back on.
I was told that the anniversary version would remove the profile facility - but, while I may not be able to set it anymore ( haven't tried) it still seems to be asking about fixes

Problem seems to be that while earlier versions of Defender went and got the updates themselves, and then windows update could be invoked for the rest of the fixes, The constraint setting seems to also stop defender automatically getting the latest definitions, and it needs prompting.
Then - you have to wait for that to finish the update (using the update engine) before you can get Windows Update to try to use the update engine

So - win-7 - I download the fix sets and do an offline update - (most restarts are without asking for confirmation - most user interaction seems to be - "accept the licence for the new version" a much faster process than having to use the MS process to access and download individual fixes.
Could be that a large proportion of the "got that block, next block please requests" from the PC are timing out and having to be re-sent again, and again and..
So keeping the PC busy waiting for data and timeouts rather than actual data processing.

But - them's just my guesses based on what I have managed to get details of, and work out!

JimB