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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156