Dynamics 365 Business Central 2023 Wave 2 release (v23) introduces a new data structure for table extensions. Instead of creating a companion table for every table extension object, v23 will store all table extension fields for a specific table in a single companion table. Performance tests show that v23 is much faster on reading and writing bulk amounts of data. Writing performances increase by +90.3433%, deleting performances increase by +44.4524%, looping through records and performing a calculation on a main table field performances increase by +51.726%, and looping through records and performing a calculation on a main table field + companion table field performances increase by +56.3673%. Dynamics 365 Business Central 2023 Wave 2 release is a release where you need to move if you want to optimize performances.
Login now to access my digest by 365.Training