AL Performance

Nov 10

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

231 views0 comments

Oct 28

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

472 views0 comments

Oct 20

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

268 views0 comments

Aug 25

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

585 views0 comments

Aug 9

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

428 views3 comments

Aug 5

SIFT

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

325 views4 comments

Jun 20

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

252 views0 comments

Nov 13, 2023

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

982 views0 comments

Nov 10, 2023

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

2,021 views4 comments

Jul 31, 2023

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

441 views0 comments

Jul 13, 2023

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

481 views0 comments

Jul 6, 2023

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

759 views0 comments

Jul 1, 2023

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

1,517 views0 comments

Jun 29, 2023

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

714 views2 comments

Jun 23, 2023

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

980 views3 comments

Mar 21, 2023

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

502 views0 comments

Aug 9, 2022

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

1,416 views0 comments

SIGN UP AND STAY UPDATED!