Hi,
we have great differences in runtimes between Nav2009-data sources and Dynamics 365 BC-data sources. For example one reports runs about 22 minutes vs. 1 hour and 34 minutes.
Does anyone has similar problems and maybe a solution?
Date
Votes
4 comments
-
Yuko Saito This seems like a common problem - its all dependent on your setting, but I presume you NAV2009 used to be connected by direct SQL connection? BC uses web-service which can be very slow.
I try to avoid using ledger tables to retrieve the information and use the analysis view table instead - this helps a little bit.
Also, where possible using NL Table and creating a pivot table from the output tends to work faster.
-
Cat Thanks for your answer. NAV2009 and BC (Dynamics365 Business Central (SQL Server)) are both connected by direct SQL connection.
Our reports are complex and most of them retrieve data from more than one company so we cannot use NL Table very often.
And the problem does not only exist with the ledger tables. But I do not know the analysis view table - is it possible we do not have it. Could you tell me which number it is?
-
Yuko Saito Analysis view - table 363 (setup table)
Analysis view entries - table 365
Analysis view budget entries- table 366
I mainly use them if the report includes dimension information.
-
Cat Ok, thanks again. We do not have this tables.
Please sign in to leave a comment.