Problem to insert a large data

[YacineCh]

Hi Team,

I have a problem, my job take a lot of hours to select 90000 from a DataBase PROD and insert them in another DataBase Archive and after Delete them from DataBase PROD.

For information :

• I Use a simple querry select with one filter.
• I use SQL SERVER DATABASE
• I use Talend Data intégration version entreprise with licence

Can you please help in thi subject !!

This is my job

[kakooo16]

What is the erreur that you are getting

[Anonymous]

Hello,

Are you getting any performance issue when inserting a large data?

Best regards

Sabrina

[YacineCh]

Hello,

I don't get any error but just the job still turn for a long time.

[Anonymous]

Hello,

Does your job work well after a long time turning? Or it is just hanging without success?

More information about your current situation will be helpful for us to address your issue.

Best regards

Sabrina