Recently, one particular piece of code in Business Central's codeunit 1501 Workflow Management once again revived the old discussion about the benefits of calling IsEmpty before actually retrieving the records with FindSet . Yes, that inexhaustible if not IsEmpty then FindSet . I already wrote about this a few times here and here . But this time the combination of IsEmpty with FindSet appeared to be a good pretext to talk about index efficiency: when a seemingly good index

Introduction of the SetLoadFields function in AL language that allowed to limit the number of fields returned to the Business Central...

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...

Back in the old Navision days, when clients' data were stored in the Navision native database instead of Azure SQL Server, and functions...

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...

According to this article on Microsoft Learn portal , non-clustered columnstore indexes (or NCCI) are seen as a possible replacement for...

Development of Business Central extensions is very much about the database communication, and as AL developers, we always control the...

In two of my previous blog posts I reviewed some pros and cons of the SumIndexField Technology (or SIFT) in Business Central. On the one...

This post is a result of one very fruitful discussion with many knowledgeable Business Central enthusiasts in a long LinkedIn thread. Now...

My previous post was dedicated to an overview of Business Central's SumIndexField Technology, or simply SIFT, which helps us collect...

SIFT, which stands for Sum Index Flow Technology, used to be a know-how in the Navision database, a data structure that stored...

Let's assume we want to select a set of customer ledger entries based on two values: salesperson code and the payment reference. Or any...

My previous post on good and bad coding practices in terms of the performance touched upon one particularly contradictory coding pattern...

This post is my shortlist of the most common beginners' mistakes in AL that affect application performance. These are not necessarily the...

Business Central table extension object, when compiled and deployed, translates to a new SQL table with the same primary key as its base...

Continuing performance testing of queries on extended Business Central tables, today I want to look at the same dataset from a slightly...

Server-side perspective One of the key characteristics of the C/AL language and its more modern ancestor, AL, that makes it so attractive...

Today, once again, I am returning to the topic of table locking, lock escalation, and the way Business Central interacts with SQL Server...

The effects of SetLoadFields and AutoCalcFields on caching This post continues the topic of query caching in Business Central which I...

A few days ago, I had a chat with a friend who asked me where his BC data access queries could be hiding from the SQL Server Profiler. He...