{"id":38490,"date":"2022-01-27T11:21:24","date_gmt":"2022-01-27T11:21:24","guid":{"rendered":"https:\/\/arquiconsult.com\/?p=38490"},"modified":"2024-10-23T11:00:21","modified_gmt":"2024-10-23T10:00:21","slug":"improve-performance-with-partial-records","status":"publish","type":"post","link":"https:\/\/arquiconsult.com\/en\/improve-performance-with-partial-records\/","title":{"rendered":"#012 IMPROVE PERFORMANCE WITH PARTIAL RECORDS"},"content":{"rendered":"
\n

Since the release of Business Central 2020 wave 2, we got a new capability called Partial Records. It consists in the possibility to specify the fields that should be loaded from a Record or RecordRef.<\/p>\n

Without the use of Partial Records, Business Central would load all data from the record even if you only needed to access one or two fields.<\/p>\n<\/div>\n

<\/div>\n
<\/div>\n
\u00a0<\/strong><\/div>\n
SetLoadFields<\/strong><\/div>\n

Specifies a set of fields to be initially loaded when the record is retrieved from its data source. A call to this method will overwrite any fields that were previously set to load.<\/p>\n

Example of code:<\/strong><\/p>\n

\"SetLoadFields\"<\/p>\n

AddLoadFields<\/strong><\/p>\n

Similar function to SetLoadFields that has one big difference: if the function is called multiple times, the new call does not reset fields that were already set (even if they were set using SetLoadFields).<\/p>\n

Important notice<\/strong><\/p>\n

If the AL Code accesses a field that has not been selected for loading, the platform will perform an implicit GET, loading all the fields from the Record.<\/p>\n

The benefits<\/strong><\/p>\n