NAV TechDays 2017: C/AL – Coding for Performance


There are several misunderstandings, confusions or “fake-news” around, when it is about C/AL programming and how it affects performance on SQL Server. Time to clean this up!

In this session we will explain some “DOs & DONTs” of programming NAV; showing best-practices in using certain methods and how to avoid common mistakes.

Further we will give some guidance about how to identify and troubleshoot query and code bottlenecks. Make your C/AL code rock!

Presented by Jasminka Thunes and Jörg Stryk

Presentation Slides & Scripts: NAV TechDays

Download Session Recording from

Watch Session on YouTube:

Directions EMEA 2017: NAV/SQL Performance in a Nutshell

Please find attached the presentations-slides (“Safe for Work” Edition 😉 ):

No worries, this session will not bother you with annoying technical details about performance optimization! I will try to describe – in simple terms – the general challenges, approaches and necessity of tuning and troubleshooting. This should help you – Dynamics Partners, Resellers and Consultants – to explain to your customers, why there actually are “performance issues” and how they could be resolved (mostly); also highlighting the value of upgrading and potential risks with Cloud scenarios.