Performance issue while reading a tab delimited file on behalf of Saurabh Marathe

PeopleTools 8.53. Using standard filelayout code to read flat file into a record. The process is taking around 4 minute to read 10000 rows. The issue is with sql calss for every row of data that gets read from the file. His question is if there is a way to read all the data from a file in rowset or a record and then perform sql insert at the end.

He tried delivered template code with Bulk Mode property without any improvement.

Below is the code:

method LoadFile
/+ &delete as String, +/
/+ &filename as String, +/
/+ &prcstype as String, +/
/+ &prcsname as String +/
/+ Returns String +/
Local string &response, &filelayout, &recordname, &msg, &retmsg, &filepath, &delimit;