tMySQLOutput extremely slow performance on remote server

[Anonymous]

tMySQLOutput with "Insert or Update" action component inserts data to the MySQL database in local network at approximate rate 200 rows/sec. However, this rate drops to 6 rows/sec for the remote database, which is absolutely unacceptable.
Can somebody, please advise, whether it is possible to fix this problem in some quick way?
The solution: "create temporary table -> bulk insert -> merge on MySQL side" is not good, because requires pervasive changes to the big integration project and it would be great to avoid it
Thanks

[Anonymous]

Hi
To optimize performance with databases, you have to find bottleneck.
Mayby this topic will help you. https://community.talend.com/t5/Design-and-Development/Performance-Of-job/td-p/97821
To get more help, a sreenshot of your job is preferred.
Best regards!
Pedro