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...
top of page
- 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...
359 views2 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...
231 views4 comments
- Jun 30
Navision legacy in AL: RecordLevelLocking
RecordLevelLocking function in AL is a heritage of the C/SIDE times and the Navision native database. In those old days when Navision...
175 views0 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...
209 views0 comments
- Jun 9
Lock timeouts and deadlocks
A long time ago (in a galaxy far away) I published some blog posts with a deeper overview of the Business Central's ReadIsolation...
655 views0 comments
- Nov 26, 2023
Read Committed Snapshot isolation and the Write Skew anomaly
Much has been said recently about the benefits of the Azure SQL for Business Central performance, and in particular a few articles...
620 views0 comments
- Nov 14, 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...
816 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...
1,736 views4 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...
450 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...
697 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,243 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...
625 views2 comments
- Jun 12, 2023
Test assertions on DateTime values
Recently, I was running a large test suite to verify my changes in the Base Application item journal posting functionality. Changes were...
233 views3 comments
- Mar 22, 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...
435 views0 comments
- Mar 20, 2023
Transaction isolation in Business Central
Business Central 22 introduces a new table property ReadIsolation which allows the developers to control transaction isolation in a more...
2,093 views1 comment
- Mar 6, 2023
Conflicting updates in concurrent Business Central sessions
After my previous posts on lock escalation, it feels like a good time to take a step to a more practical plane and investigate some real...
881 views0 comments
- Feb 23, 2023
AL updates and locking, Part II - Optimized locking in Azure SQL
In my previous post AL updates and locking, I gave a high-level introduction into the SQL Server locking model. That post was inspired by...
491 views0 comments
- Feb 19, 2023
AL updates and locking, Part I - Introduction to lock escalation
Recently Microsoft announced significant changes in the SQL Server locking architecture which can dramatically reduce the number of lock...
807 views0 comments
- Feb 13, 2023
How come the size of my Sales & Receivables Setup table is 16KB?
And Bank Account Ledger Entry is non-integer? What's behind Business Central table information Have you ever asked yourself, looking at...
162 views0 comments
bottom of page