Data was loading very slowly, due to transform map scrips

[harish mandhula]

We have on before and on after transform map scripts, when we are doing data load the records was inserting very slowly. It was taking lot of time to insert the records.

To avoid this what  we can do, please let us know

[Shekhar Navhak1]

yes, can you try it in lower instance

[harish mandhula]

I have tried the above script in dev instance, it was working very slowly.

i am using scoped application, and in scoped application we have customized table.

those are the above scripts we are performing on custom table, created data source and transform map scripts in scoped application.

The data was loading very slowly, due to transform map scripts.

what can be do, i have not created index on coleasce fields is it reason for data loading very slowly.

[OlaN]

Without knowing the details of your instance, I would say that your query is incorrect.

You are doing a query on two different fields on incident "imported" and "incident_id".

As far as I know, there is no such fields OOB on the incident table, meaning your query is invalid, and depending on the settings on the instance, will return ALL incident records.

And since you are looping through all found records, and updating them one by one, this script will be very slow.