tMySQLOutput extremely slow performance on remote server

Highlighted
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
Highlighted
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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog