Home /

SQL

4 articles
AL Language

Partial Records in detail (part 2)

This is another article about Partial Records (as we already discussed earlier in the article about Partial Records and later in the first part of articles about partial record’s performance). In this article, we will explore the ration between performance, partial records and system with more tableextensions. Let’s start with the example of our AL

5 min read
AL Language

Partial Records in detail (part 1)

Partial Records in the Business Central are a new technology in 2020 wave 2 release. Let’s look at the quick description in one of the posts from previous month “Partial Records“. Now check it in more details. In this first part, we will look at how the partial records work and what is behind these

5 min read
AL Language

Partial Records

Partial Records are a new capability of Business Central introduced in Business Central 2020 release wave 2. It allows specifying fields that should be loaded when accessing SQL based data. How does it work? Without using partial records, Business Central normally load all data from the record even if only one of them is required.

3 min read