What is the standard speed of data format conversion (CSV, XML)?

Question

1. What is the standard speed for the data format conversion from CSV to CSV?
2. What is the standard speed for the data format conversion from CSV to JSON?

Answer

Here are the results of our verification as a benchmark.
However, conversion speed depends on file size, resource size of the Integrate service, etc.
Please consider the result as one of the references and verify the actual conversion speed with your own files.

Standard speed of data conversion from CSV to CSV

File Size, Number of Records, Processing Time (sec)
10MB, 10000, 12
50MB, 50000, 49
100MB, 100000, 109
200MB, 200000, 330
300MB, 300000, 1078
500MB, 500000, 1871

Standard speed of data conversion from CSV to XML

File size, CPU, Memory (GB), Average processing time (sec)
Approx. 500MB, 1, 8, 99.91
Approx. 500MB, 4, 8, 54.55
Approx. 500MB, 4, 12, 54.16

Supplementary information

We do not have benchmarks for JSON conversion speed, since HULFT Square does not provide JSON conversion connector.