Dynamics 365 Business Central 2025 Wave 2. What’s New in Performance.
Version 27 of Dynamics 365 Business Central introduces six performance enhancements across application, development, and SQL optimization areas, including optimized flow fields, SQL statements in AL profiles, and new AL functions like LockTimeoutDuration and CreateSequentialGuid.
post Dynamics 365 Business Central tales, myths, legends. And something serious.
"all of the features are CUMULATIVE, hence the latest version is always the fastest on the market"
Key points
- The author highlights six version 27 performance items in three groups: application, development and SQL optimization
- Application: sorting by Type and Line No. in sales and purchase postings, plus SQL statements in AL profiles
- Development: new LockTimeoutDuration, CreateSequentialGuid and Truncate in AL
- SQL optimization: flow fields sharing the same table and filters are combined into one OUTER APPLY, which applies automatically
- The author ranks this release fourth for performance impact since 23.x and stresses that performance gains are cumulative across versions
Quotes
- “all of the features are CUMULATIVE, hence the latest version is always the fastest on the market” (Clarifies that performance improvements stack across versions, meaning adopting the latest release automatically provides cumulative benefits)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- other “LockTimeoutDuration in AL”
- other “CreateSequentialGuid in AL”
- other “Truncate in AL”
Context
- Features: Sorting by Type and Line No. in Sales and Purchase Postings, SQL Statement in AL Profiles, LockTimeoutDuration, CreateSequentialGuid, Truncate function, Flow Fields optimization with OUTER APPLY
- Versions: 27, 2025 Wave 2
Source: Duilio Tacconi, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.