Hi, we’ve used Bi-Weekly Time Report for years in NAV2015 and just recently moved to BC20. The report would take about 30 seconds to run in NAV2015 and running same report with same filters/config takes 6-10 minutes on BC. Any ideas why the report would be taking so much longer? Other base-BC reports run as expected.
For on-prem version typically the culprit for reports being slower or faster after upgrades, would be due to SQL Indexes and Index maintenance. SQL administrator would be ideal to look for and resolve fragmented SQL index, as that typically would improve performance.
If you need further advice and guidance on the matter, please submit a support ticket to our support portal.
This reply was modified 10 months, 1 week ago by Olina Thorsteinsdottir.