#msdyn365bc 2021 Release Wave 2 - Performance – partial records.

Hi Readers,

In this series we will discuss what's new in Business Central 2021 (Wave 2) a.k.a BC19.

This article we will discuss about - Performance – partial records on list Page and TableRelation lookup pages.

With this series we will understand what's new the product and learn it before it becomes available for customers.

#msdyn365bc #2021RW2

Feature Details - 

• List pages now load faster.
• TableRelation lookup pages are now much faster.

Explanation -

• Microsoft Introduced Partial Records in Previous Releases in Business Central.
• With Business Central 19, Microsoft have enhanced Partial Records to Pages in Platform.
• Only fields which are part of the list page & Lookup page design will be loaded from SQL Server while trying to fetch records.

Example - 

• A Sample Customer Page with Just 3 Fields (No., Name and Location Code).

• Before Business Central 19 while trying to run the page SQL Query will fetch all fields as shown below. If table have table extension, then those are also loaded from SQL Server.

• As Highlighted this loads fields from table extension and also create joins for each table extension.

• Starting Business Central 19, with Partial Records - Only Primary Key Fields, System Audit Fields and some other fields will be loaded.

• As Page does not contain a field from table extension, system did not load fields and nor create join to Table Extension.

Based on this small change the performance of List page will improve drastically.

Hope you learn and will be able to utilize this feature as Business Central 19 is available.  

For other articles related to What's New in Business Central 19, refer here.

Regards,
Saurav Dhyani
www.sauravdhyani.com