Skip to main content

#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

Comments

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Dynamics 365 Business Central 2021 release wave 2 (BC19) Released.

Hi Readers, As we all were expecting Microsoft have Released Business Central 2021 Release Wave 2 Today a.k.a BC19. In this article we will see what all is announced with the General Availability.  Starting Today Customers & Partners can start using Business Central 19. #msdyn365bc #bc19

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------