Performance in AL Language development (BC2021 wave 2)

by Sep 29, 2021AL Language

Home 9 Development 9 AL Language 9 Performance in AL Language development (BC2021 wave 2)

In just a few days the new major version of Business Central 2021 wave 2 will be introduced! This is again a huge set of changes that comes with this new version.

In this article, we will look at the most important changes in AL Language performance (performance snapshot debugging and changes in development to reflect performance issues).

 

Profiling AL performance with Snapshot Debugger

Until now, there has been no existing way of measuring the performance of development execution and troubleshooting cases of performance issues. Since performance is a priority in online businesses, Business Central introduces execution timing capture as a snapshot or part of it.

Snapshot captures will catch the executed code’s profile, and the AL Language extension for VS Code will have a performance profiling editor view so developers can dissect performance execution with call stack views.

Support for included columns in the keys

Developers can modify indexes to included data required for some queries using the partial record loading feature, and these data can be loaded quickly using the index pages.

By using the keyword IncludedColumns in the key definition while creating indexes with included columns, developers can now create indexes that perform great.

Benefits of indexes with included columns are:

    1. In an index definition, included columns will not count against the limit of 16 fields (maximum number of fields that can be part of the key). Included columns do not count to this limit.
    2. It requires less database I/O.
    3. It is smaller and more possibly cached.

Support for non-clustered column store indexes

With the Business Central 2021 wave 2 developers can create NCCIs (non-clustered column store indexes) by using the keyword Columnstore in the table definition. NCCIs may have multiple performance benefits in reducing table locking caused by maintaining original SIFT indexes (which can be replaced by modern NCCI technology).

NCCIs provide a better performance, especially when developers use SetAutoCalcFields for fields without SIFT index.

Recent Articles from the category

Collectible Errors?! Is it already in use?

Collectible Errors?! Is it already in use?

Collectible Errors?! Is it already in use? This is the second part of my new article series about Collectible Errors. Let's check out the first part here: Collectible Errors?! | Microsoft Dynamics 365 - Ing. Tomáš Kapitán (kepty.cz) or you might be interested in my...

read more
Collectible Errors?!

Collectible Errors?!

Collectible Errors?! It has been already almost a year since ErrorInfo datatype & CollectibleErrors were introduced (I already have an article about basic structure: ErrorInfo data type & Collectible Errors). This article was released for the first time in...

read more
Substituting standard reports

Substituting standard reports

Report objects cannot be extended in versions previous to the Business Central 2021 release wave 1 version when ReportExtensions object was introduced. Since then, many of changes we need to do in reports can be done without creating a new copy of object. On the other...

read more
Isolated events

Isolated events

With Business Central 2022 wave 1, a new setting for event publishers was introduced. Until this version, any error in any event subscriber caused interruption to the current running process and stopped the whole activity. In some cases (such as log-in), this is...

read more
Custom Filter Tokens

Custom Filter Tokens

As a user of the Business Central you have some constants you can use to filter or insert values. These constants contain useful values for data manipulation such as t / today for date field - return current dateq / quarter for date field filters - return range of the...

read more
How to let users choose field(s) properly

How to let users choose field(s) properly

When some complex functionality is developed, it is sometimes necessary to let users choose a specific field. This can be required for field permissions, mapping imported values or any similar process. Earlier, the usual way was to create a link on the Field table...

read more
Working with Translation Files (XLIFF)

Working with Translation Files (XLIFF)

How does the translation file work? In Microsoft Dynamic 365 Business Central, displaying different languages is done using the XLIFF files extension (.xlf). The generated XLIFF files have strings that are specified in properties like Captions, Tooltips......

read more
1D & 2D Barcodes in Business Central 19.1

1D & 2D Barcodes in Business Central 19.1

Business Central (cloud-only!) includes one-dimensional (1D) barcode fonts since Microsoft Dynamics 365 Business Central 2020 wave 2 (17.0) was released in October 2020. It is a great improvement to how developers can handle requirements from their clients to print...

read more
ErrorInfo data type & Collectible Errors

ErrorInfo data type & Collectible Errors

A major change to AL Language development is here! Collectible errors can hugely improve any validation procedures. And what's new? Everything is about a new data type ErrorInfo. ErrorInfo data type ErrorInfo is a new data type introduced in Microsoft Dynamics 365...

read more

Sign Up for News

Certifications

Highest certification
Microsoft Data Management and
also in D365 Business Central

Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate

See other certifications here