Import batch

The import batch in SQL DataTool defines the amount of records that will be imported at once. When you use the import data functionality of the SQL DataTool, the import batch is the number of records that will be assessed and imported at once. Depending on the speed and stability of the connection, the import batch number can be increased or decreased. As a default, the import batch is configured to be 100,000 records.

The higher the import batch records, the faster the data import will be finished. However, when the connection is lost while importing a batch, an error will be shown.

To change the import batch, open the configuration screen. Then change the number in the import batch records field.

Configuration - general

The minimal batch size is 1. There is no maximum to the import batch.

When you have changed the import batch, always click on the 'Save' button.