top of page


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
722 views
0 comments


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
350 views
0 comments


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
698 views
0 comments


Covering indexes as an alternative to SIFT
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...
Oct 20, 2024
369 views
0 comments


if not IsEmpty then FindSet... Or not?
This post is a result of one very fruitful discussion with many knowledgeable Business Central enthusiasts in a long LinkedIn thread. Now...
Aug 25, 2024
767 views
0 comments


The dark side of SumIndexFields. Concurrency.
My previous post was dedicated to an overview of Business Central's SumIndexField Technology, or simply SIFT, which helps us collect...
Aug 9, 2024
505 views
3 comments


SIFT
SIFT, which stands for Sum Index Flow Technology, used to be a know-how in the Navision database, a data structure that stored...
Aug 5, 2024
418 views
4 comments


Select with partially matching index: can we make it faster?
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...
Jun 20, 2024
301 views
0 comments


if not IsEmpty() then DeleteAll()
My previous post on good and bad coding practices in terms of the performance touched upon one particularly contradictory coding pattern...
Nov 14, 2023
1,188 views
0 comments


Top 5 AL mistakes that undermine performance
This post is my shortlist of the most common beginners' mistakes in AL that affect application performance. These are not necessarily the...
Nov 10, 2023
2,459 views
4 comments


How scary are table extensions?
Business Central table extension object, when compiled and deployed, translates to a new SQL table with the same primary key as its base...
Aug 1, 2023
471 views
0 comments


When partial records and indexes reach synergy
Continuing performance testing of queries on extended Business Central tables, today I want to look at the same dataset from a slightly...
Jul 13, 2023
520 views
0 comments


Who benefits from partial records: The true magic of SetLoadFields
Server-side perspective One of the key characteristics of the C/AL language and its more modern ancestor, AL, that makes it so attractive...
Jul 6, 2023
860 views
0 comments


Locking Scope: Differences between LockTable and ReadIsolation
Today, once again, I am returning to the topic of table locking, lock escalation, and the way Business Central interacts with SQL Server...
Jul 1, 2023
1,894 views
0 comments


Introduction to Business Central Caching - Part 2
The effects of SetLoadFields and AutoCalcFields on caching This post continues the topic of query caching in Business Central which I...
Jun 29, 2023
828 views
2 comments


Introduction to Business Central caching
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...
Jun 23, 2023
1,160 views
3 comments


ReadCommitted isolation in Azure SQL
In my previous post Transaction Isolation in Business Central, I introduced a rather long and detailed review of transaction isolation...
Mar 22, 2023
607 views
0 comments


Performance of event subscribers. SingleInstance or not?
There are countless factors that can affect application performance - structuring of the code, an algorithm that we chose for a specific...
Aug 9, 2022
1,608 views
0 comments
bottom of page