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
1 REPLY
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