Limits of Using Multi-threaded CSV Import

If your import file contains multiple lines of data for sublist lines, you must consider whether you can use multi-threading to import the data. Multi-threading can lead to errors if the import file is structured incorrectly.

In the following example, each section marked with red is processed as one record.

CSV import file where each section is processed as one record.

In this case, multi-threading works, but only if your import file is structured in a way that the lines that refer to the same record are consecutive.

In the following example, multi-threading can lead to an error because the lines referring to the same record are not consecutive. The first two lines of this example are processed as one record, and if multi-threading is used, it is possible that the process works on the last line at the same time, which modifies the same record.

Example of multi-threading that can lead to an error.
Note:

When using an import file that contains multicolumn sublists, each line of the CSV file is submitted separately.

Example of a CSV file with multicolumn sublists.

Related Topics

General Notices