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: Bulk
Dynamics 365 Business Central: How to bulk edit user roles/profiles (Customization)
Last week we briefly discussed how to define default Role Center (Profile) for users in Business Central.
Then I received an interesting feedback. They had imported users, and the number of users is relatively large. They were looking for an easy way to edit the user roles in bulk.
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:
Bulk Edit and Add Customers via Excel in Dynamics 365 Business Central
Manually adding or editing multiple customers to your database is frustrating, not to mention time-consuming. With the new release of Business Central you now have the ability to bulk add and edit customers via Excel. Now that’s something to get excited about
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.
Creating Production Orders in Bulk Using the Microsoft Dynamics NAV Planning Worksheet
We have a couple of clients that have not yet gone live with the MRP (Planning Worksheet) functionality in Dynamics NAV. They determine the need for Production Orders outside of Dynamics NAV and then create the production orders one at a time in NAV. There are times when they create over 100 production orders in a day.
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