Optimizing SQL Server performance
There can be several factors that contribute to the slow performance of a system. In this section, we are trying to focus on some of the basic elements.
Data access
In Microsoft Dynamics NAV Version 2009 and earlier, Dynamics NAV was used for Open Database Connectivity (ODBC) as an API to connect to the database. But thereafter, it has implemented the ADO.NET API to interface with the SQL Server. There are many advantages of using ADO.NET over ODBC. We shall discuss them briefly.
ADO.NET and ODBC are both Microsoft Standard Application programming interfaces. ADO.NET is quicker and gives flexibility in its setup in comparison to its counterpart, ODBC. Here are some of the benefits of using ADO.NET over ODBC:
- Simple ...
Get Mastering Microsoft Dynamics NAV 2016 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
