Significant loss of performance after move from Access 2016 (32 bit) to Access 365 (64 bit)
Hello,
In absence of SQL Server data repository, I developed an Access application that imports data from various sources and writes it to text files that are then linked so that I can run Excel reports against it. The daily import used to take about 60 to 75 minutes to complete, but since my company moved to Office 365 it is taking more than 8 hours to run completely. I believe that the excess latency is related to running the queries but that is as far as I have been able to get. Some of the queries are pass-through queries and they are slower than before; however, the queries that are taking the longest are those that are running against the linked tables within the database itself. The database and all of the linked text files are located on my local drive, so it isn’t a network issue.
All that said, does anyone have any idea why SQL queries running against locally linked tables take multiple hours to complete in Access 365 (64) when the same queries would run in under 15 minutes in Access 2016 (32)?
Hello,In absence of SQL Server data repository, I developed an Access application that imports data from various sources and writes it to text files that are then linked so that I can run Excel reports against it. The daily import used to take about 60 to 75 minutes to complete, but since my company moved to Office 365 it is taking more than 8 hours to run completely. I believe that the excess latency is related to running the queries but that is as far as I have been able to get. Some of the queries are pass-through queries and they are slower than before; however, the queries that are taking the longest are those that are running against the linked tables within the database itself. The database and all of the linked text files are located on my local drive, so it isn’t a network issue. All that said, does anyone have any idea why SQL queries running against locally linked tables take multiple hours to complete in Access 365 (64) when the same queries would run in under 15 minutes in Access 2016 (32)? Read More
