top of page

Key to Good Code
DEVELOPER'S VIEW ON MICROSOFT BUSINESS CENTRAL


JIT loads vs Full record load
Since the time when I came across this post by Waldo (or actually, he mentioned his test results in one online discussion) I was curious...
May 31
Â
Â
Â


To sort, or not to sort, that is the question
Back in the old Navision days, when clients' data were stored in the Navision native database instead of Azure SQL Server, and functions...
May 30
Â
Â
Â


Garbage collection of event subscribers
I once wrote a post on event subscribers and the presumed performance benefits of single instance subscriber codeunits, but the topic...
Apr 12
Â
Â
Â


Recursive AL
Recently I heard an opinion shared by some AL developers that recursion in AL can be dangerous and should be avoided because the AL...
Apr 5
Â
Â
Â


Buffered inserts and deadlocks
Recently I was debugging a very interesting deadlock case which I want to share in a blog post now. It was especially curious because, as...
Feb 22
Â
Â
Â


Filtering on FlowFields
It has been said so many times that filtering on FlowFields is bad for performance that we are used to avoiding this kind of filters in...
Feb 6
Â
Â
Â


Table indexes and inserts
Following my series of posts where I have been addressing various aspects of table indexing, this post delves into the same old argument...
Dec 21, 2024
Â
Â
Â


Temporary tables in procedure parameters
When we declare multiple instances of a record variable referencing the same table in AL code, we essentially receive different instances...
Nov 24, 2024
Â
Â
Â


Another alternative to SIFT: Columnstore indexes
According to this article on Microsoft Learn portal , non-clustered columnstore indexes (or NCCI) are seen as a possible replacement for...
Nov 10, 2024
Â
Â
Â


Hidden SQL queries in AL you (probably) want to avoid
Development of Business Central extensions is very much about the database communication, and as AL developers, we always control the...
Oct 28, 2024
Â
Â
Â
bottom of page