AL Performance

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

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

1,008 views4 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...

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

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

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

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

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

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

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