Update in tmssqloutput is taking too much time

[NNayal1600240775]

Hi,

I need to update 2 columns of the table for around 5k records but the commit is taking too much longer -approx more than 1 hr. Any suggestion on how to make this process faster as i have around 50k record to update and that takes more than 7-8hrs.

 

this is advance setting for tmssqloutput & tmssqlconnection:  

[Stephen_Elves1]

Experiemnt with using the Bulk versions of the output components they are generally MUCH quicker.

[Anonymous]

Hello,

In your job, there is a tMap component which is a cache component and consuming too much memory.

For a large set of data, please try to store the data on disk instead of memory on tMap.

Bets regards

Sabrina

[NNayal1600240775]

Hi @Xiaodi Shi​ i added Store temp data ='true' in the lookup table.

and in tmap setting i added path of store on disk as i have mentioned below - but still i get the same results . its taking too long to commit the updates same as before.