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

Bron : TharangaC – Dynamics NAV Blog
Lees meer…