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.
Posted inDynamics NAV & BC Tips & tricks