I have migrated my MYSQL databases to Amazon RDS. I am trying to get the data from SQL server to Amazon RDS mysql through talend. However, the jobs run very slow. A 50000 rows insertion takes an hour of time. Whereas, when I use the Talend Amazon components, tAmazonMysqlOutput, the same job completes in less than a minute
May I know what is the reason for this? If I change all my regular mysql components to Amazon mysql components would there be any issues?
Any ideas on this would be of great help
Usually, we use tAmazonMysqlXXX to connect DB which is on Amazon service.
From code side, tAmazonMysqlXXX and tMysqlXXX are same.
Thank you Sabrina
But why is it the job timing increases when I connect to the Amazon RDS instance? Even when I change the components to amazon mysql components, the performance is too slow