Be careful with dynamic code

I believe there is a time in every AL developers live where he discovers the power of RecordRef and FieldRef. It is surely Incredible what you can achieve with these tools and how fast you can deliver a pretty good working piece of code. At least this is the way I remember my first solutionsContinue reading “Be careful with dynamic code”

Performance & Variables exposed as field on a Page

Today was again one of those days… I just wanted to add a flow field to a table to look up some value, and display it on a list page. After some time I realized that this wont work. Im my case I needed to go three table relations deep to get out the valueContinue reading “Performance & Variables exposed as field on a Page”

Coding4Performance 5: FindSet vs FindFirst

Today in coding for performance, we talk a bit about FindSet and FindFirst. I actually had plans to make this one the first post in this series. But it turned out that the differences between this two commands are not as obvious as I first thought. Let me first place a huge disclaimer here: EverythingContinue reading “Coding4Performance 5: FindSet vs FindFirst”

Coding4Performance 4: Task Scheduler

In my last post about Start Session I explained how you can easily run a Codeunit in background and relieve the user session. The downside on this method is, that your background task still runs on the same server instance like the user session does. If you have only a few users and only oneContinue reading “Coding4Performance 4: Task Scheduler”

Coding4Performance 3: Start Session

As promised, here the first (and easiest) way to run code in background. This blog will be a bit shorter, as Start session is quite straight forward. Note: If you did not read the previous blog about Background tasks in general, maybe you should start there 😉 I created an example scenario for which aContinue reading “Coding4Performance 3: Start Session”

Coding4Performance 2: Asynchronous development and background tasks

In this post I will explain the general concept of asynchronous development and background tasks. So everyone knows how procedural development works. In Business Central it starts with a user which logs in to the web client and starts a user session. The first page which opens is most likely the role center page. BehindContinue reading “Coding4Performance 2: Asynchronous development and background tasks”

Coding4Performance 1: Text Builder

As NAV and Business Central evolves user tasks become more complex and BC becomes more powerful to solve this tasks. But this happens often with cost in performance. Even Microsoft published a (very good) article about how to improve performance in BC. I do mainly concentrate on the developer aspect of this article and inContinue reading “Coding4Performance 1: Text Builder”