web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 408

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.

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    on at
    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.

  • Suggested answer
    Bilal Haider Profile Picture
    408 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,808

#2
Sumit Singh Profile Picture

Sumit Singh 2,554

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,140

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans