batch-delay-interval

Definition

Gets or sets a delay in milliseconds to wait between batch.

DO NOT use this options with transaction.

Example

// Instance
context.BulkInsert(list, options => options.BatchDelayInterval = 100);

// Global
EntityFrameworkManager.BulkOperationBuilder = builder => builder.BatchDelayInterval = 100;

Purpose

Having access to add a delay interval between batch may help to let to responsivity to other applications by giving them a chance to insert data during the delay time.

FAQ

Why should I not use this options with transaction?

You should not because if may often lead to lock and deadlock.

A transaction must be a short as possible and completed as soon as possible.