tMySQLOutput extremely slow performance on remote server

Anonymous — Sat, 16 Nov 2024 12:33:18 GMT

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

Re: tMySQLOutput extremely slow performance on remote server

Anonymous — Wed, 30 Nov 2011 03:54:39 GMT

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

topic tMySQLOutput extremely slow performance on remote server in Talend Studio

tMySQLOutput extremely slow performance on remote server

Re: tMySQLOutput extremely slow performance on remote server