Today I’ve discovered that not everyone knows how Dynamics 365 Business Central (but also Dynamics NAV) handles inserts on the SQL backend, so I think it’s worth writing a quick post on explaining this.
Tag Archives: Insert
When it comes to Insert(), I’m shopping Bulk!
In this video, I demonstrate how effective Insert() can be if you use Bulk Insert, check it out:
Tip #52 – Run MODAL pages after INSERT
One of the things I spend a lot of time on during my workshop is design for performance and using temporary tables. There are so many great things you can do here.
Let’s look at this code:
Bulk Inserts – in NAV 2015
By default, Microsoft Dynamics NAV automatically buffers inserts in order to send them to Microsoft SQL Server at one time. By using bulk inserts, the number of server calls is reduced, thereby improving performance. Bulk inserts also improve scalability by delaying the actual insert until the last possible moment in the transaction.
Microsoft Dynamics NAV DotNet objSelection.InsertFile
With the Microsoft.Office.Interop.Word library are almost infinite possibilities open to you interact with Microsoft Dynamics NAV and Office.
I want to show you a short example today, how you can insert such as an existing Word file in a new created document at the end.
Bulk Inserts – Dynamics NAV
Microsoft has introduced the bulk insert functionality which will allow the developers to write high performance code.
What is Bulk Insert :
Microsoft Dynamics NAV automatically keep all the records in a buffer and then send them to Microsoft SQL server at a one time. Before this modification, insert happen in the order of the C/AL code running and had lot of server calls which will slowdown the application and also lock the tables many number of times before completing a one transaction
How to bulk insert users in a NAV 2013 database?
You need to insert a lot of users to a navision 2013 database. First you select the users you want by running this commandline…