Performance of Number Series and Number Sequence

It is fairly common practice to use Number Series to generate a key field value for a table in Business Central. This is very convenient, but do you know how slow it is? Let’s try to look at examples and performance measurements, talk about Number Series and Allow Gaps, as well as Number Sequence.

Source : Volodymyr Dvernytskyi
Read more…

How to design a high performant inventory report in Business Central

If we want to answer a simple question in Business Central – “How many items we have in each location?” then there aren’t that many great built in reports available. There is the standard “Items by Location” report that is not that great. It doesn’t offer exporting, doesn’t offer filtering, you can’t see item values etc.

Source : D365 BC & Power Apps
Read more…

AL Performance Profiler

Microsoft has enhanced the AL performance profiler (available starting from version 19 only via Visual Studio Code) giving the possibility also to functional developers/consultants, as well as customer administrators and power users to capture a user flow from within the web client and view high-level information about time spent in the web client itself.

Source : Madhda
Read more…

Setting the Sampling Interval for (in-client) performance profiling Business Central

You’re probably very much aware of the Performance Profiler in Business Central: an ability to monitor code execution in terms of “durations” and “hit count”, and having a view on how the code/process performed. As a first version, we had in v19 the AL Performance Profiler where we could profile from VSCode, and analyze the result in VSCode as well. Awesome tool, which looks something like this:

Source : Waldo’s Blog
Read more…

4 Ways To Boost Performance With Background Processes In Business Central

In this article, you will learn about 4 ways to boost performance with a background process in Microsoft Dynamics 365 Business Central. These methods are Page Background Tasks, the StartSession function, the Task Scheduler, and the Job Queue. Also, you will find the difference between them and how to apply each one depending on the scenario.

Source : Business Central Geek
Read more…