Question
I am using a Write CSV File operation in a loop operation, but I feel that the process is slow.
What should I review to make the process faster?
Answer
When a file connector (except Excel connector) such as Write CSV File operation is placed in loop operation, performance is degraded because the file to be written is opened and closed in each loop.
Please refer to the following page for information on how to reduce the frequency of file openings when Write CSV File operation is used in Loop by Number of Data operation.
When writing operation of a file category connector is placed in loop processing - Loop by Number of Data
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/flow_loop_by_number_of_data.htm
Comments
0 comments
Article is closed for comments.