Welcome to MSDN Blogs Sign in | Join | Help

April 2008 - Posts

Monday, April 21, 2008 7:49 AM

SQLIndex property

In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm performance. In this blog I describe what to be careful about, and why the use of this property has been removed in the NAV 5 SP1 application. The property is
Posted by Lohndorf | 9 Comments
Filed under:
Monday, April 14, 2008 11:18 AM

Bulk Inserts in Microsoft Dynamics NAV 5.0 SP1

Bulk Inserts is a new feature in NAV 5.0 SP1 which is designed to improve performance when inserting multiple records by delaying the physical inserts on the SQL Server. Before this change, inserts happen in the order that the C/AL code is running. With
Posted by Lohndorf | 2 Comments
Filed under:
Friday, April 04, 2008 12:55 PM

My experiences with Microsoft Dynamics NAV 5.0 SP1 …

I spent last week performing a Microsoft Dynamics NAV 5.0 Update 1 to Microsoft Dynamics NAV 5.0 SP1 database conversion for a customer. The process went very smoothly and the customer was very excited about the increase in performance we were able to
Posted by rmiller | 5 Comments
Thursday, April 03, 2008 7:39 AM

SQL Pre-processing in Microsoft Dynamics NAV 5.0 SP1

One of the major changes in Microsoft Dynamics NAV version 5 SP1 (in relation to performance on SQL Server), is a new way to send queries to SQL Server. In previous versions of NAV, we some times saw SQL Server 2005 optimizing query plans for extreme
Posted by Lohndorf | 6 Comments
Filed under:
 
Page view tracker