Optimization – Pardaan.com

A Couple of RDLC Performance Optimization Tips

We have received several requests related to optimization tips for the Microsoft Dynamics NAV RDLC report experience. So in this blog post we provide you with a couple of tips for how you can refactor a report in order to increase its performance in terms of…

23 March 2015

Dynamics NAV & BC Tips & tricks

The Value of Code Optimization in NAV

In earlier versions of Dynamics NAV, specifically up to NAV 4.0, certain functions were written in order to speed up processing in the Native client. However, when moving to SQL platform, these functions can cause performance issues in large databases. For the purpose of performance optimization,…

20 December 2013

Dynamics NAV & BC Tips & tricks

Bootcamp Notes: SQL Optimization

I’m back again with one of my Bootcamp notes. This time a few points about optimizing for SQL Server. There have been a lot of changes on SQL Server. It is no longer using cursors through OLE DB to connect, but MARS (Multiple Access Result Sets)…

4 March 2013