I hope you will be able to help me out. We have a services that reads flat file and then inserterts the data from the flat file into the database. For each record the flat file adapter reads and the insert service is being called. This works fine but for it takes 40mins to do 50,000 records which is way to slow. Is there anyway to read all records and make one database call instead one for each record?
Any help greatly appriciated!!!