Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Microsoft Dynamics NAV 2016

You're reading from   Mastering Microsoft Dynamics NAV 2016 The compilation of best skillset to harness Microsoft Dynamics NAV for Administrators, Consultants, and Developers

Arrow left icon
Product type Paperback
Published in Mar 2017
Publisher Packt
ISBN-13 9781786464309
Length 450 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Rabindra Sah Rabindra Sah
Author Profile Icon Rabindra Sah
Rabindra Sah
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Microsoft Dynamics NAV Installation FREE CHAPTER 2. Upgraded Features and Configuration in Dynamics NAV 2016 3. The C/AL and VB Programming 4. Testing and Debugging 5. Design and Development Considerations 6. Version Control and Code Management 7. Tuning Up the NAV System 8. Security in Dynamics NAV 2016 9. Upgrade and Migration 10. Interfacing NAV with Other Applications 11. Extending Dynamics NAV 2016 12. The Future of NAV

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 setup

  • Better compatibility with the Windows server

  • Resource-efficient

  • Better caching

  • Better performance

Database information

We can make changes to the existing database by going to File | Database | Alter from the development environment.

Collation setting...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime