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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / My New sales order tab...
Small and medium business | Business Central, N...
Suggested Answer

My New sales order table is taking time to load.

(0) ShareShare
ReportReport
Posted on by Shankar 75

I have created a new table where my all sales order, archive table and posted sales order are seen, when there are multiple record my page is taking time to load, how can we manage that in Al code.

Sometimes 10,000 records are showing, so how can I control that, so that there will be no delay in loading my page.

I have the same question (0)
  • Govinda Kumar Profile Picture
    Govinda Kumar 2,304 Moderator on at
    RE: My New sales order table is taking time to load.

    Hi,
    I'm not sure how you're retrieving data for your table or which queries you are using, but I think you need to optimize it for better performance.. you can also refer to this document it provides a guide for coding for performance in business central fredborg.org/.../Guide-Coding-for-Performance-in-Business-Central.pdf
    I hope this helps.
    Regards.

  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,294 Moderator on at
    RE: My New sales order table is taking time to load.

    Hi Shankar - There's a reason why Microsoft has created separate tables for all the transactions you've mentioned above. The main reason being - The data in these tables can be humongous sometimes in GB's. For whatever reason the customization may have been accomplished, no matter how many lines of code you optimize now, the page will load slower by each passing day and you just may not be able to do anything about it. It's the amount of data that is being displayed on a single page which is rather unfair to the overall ERP, you can't question page/BC performance here.

    There's still time to re-visit your old requirements and remove this page and rather use the individual pages built by Microsoft. You can build a report for this purpose governed/executed by date filter and/or customer and/or other parameters rather than just displaying the whole dump in a page.

    You are doing nothing but replicating GBs of data from one table to another, which will also result in increased consumption of your allocated database space (if you're using SaaS) or can slower the whole BC performance (if you're using On-Prem). I have seen Posted Sales Invoice & Archive table grow exponentially and I know how difficult it becomes to manage such a solution

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans