tMySQLOutput extremely slow performance on remote server

One Star

tMySQLOutput extremely slow performance on remote server

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
One Star

Re: tMySQLOutput extremely slow performance on remote server

Hi
To optimize performance with databases, you have to find bottleneck.
Mayby this topic will help you. http://www.talendforge.org/forum/viewtopic.php?id=16949
To get more help, a sreenshot of your job is preferred.
Best regards!
Pedro