Bulk Inserts

Bulk Inserts In Dynamics NAV

Microsoft Dynamics NAV automatically buffers inserts in order to send them to 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. This reduces the amount of time that tables are locked; especially tables that contain SIFT indexes.Application developers who want to write high performance code that utilizes this feature should understand the following bulk insert constraints.

For More Information Visit: Navision World