I would like to improve processing speed of script that splits source CSV file into multiple CSV files according to certain rules

Question

As shown in the figure below, I created a script to split a soruce CSV file into multiple CSV files according to certain rules, but it takes a long time to process.
Is there any way to speed up the process?

The script reads master data from the source CSV file and splits the data into multiple CSV files according to the values in an appropreate column.

Answer

Because Write CSV File is placed in Loop by Number of Data, file access is made for each record in the source CSV file, which may significantly reduce the script processing speed.
Please consider using Transaction as it may improve the processing speed.

<How to enable transaction processing>
As shown in the figure below, enclose Loop by Number of Data in Transaction and check [Execute transaction processing] checkbox of Write CSV File.