Small and medium business | Business Central, N...

MARK filter causing performance issue while using in BC On-Prem

(0) Share

Report

Posted on by Bilal Haider

248

Hi,

We have a code that is written on Item Ledger Entry to do some cost calculations in BC14. We have used MARK function to mark records. Then we use those marked records in calculations. On using the marked ones the NEXT function is taking a few seconds on each iteration. The Item Ledger Entry table have around 2 million entries so it makes sense to take time.

But interesting thing is that in NAV 2009 R2 same code is working extremely fast with same dataset. Is there any difference in the MARK functionality in 2009-R2 and BC 14.

All responses (2)

Answers (0)

Suggested answer

Bilal Haider 248 on at

Like (0)

Report

RE: MARK filter causing performance issue while using in BC On-Prem

I have found a way to solve this using temporary tables rather than marking.

I moved the filtered records to a temporary table and then use it in calculations. It make it super super fast.
Suggested answer

Andy Sather on at

Like (0)

Report

RE: MARK filter causing performance issue while using in BC On-Prem

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.