Job Performance tuning

One Star

Job Performance tuning

Hello,
I am new to Talend and would like to ask some questions on various topics.
The very first issue I ran into is poor job performance.
I have a simple job which reads Excel file, single tab and loads the data into a table (MySQL database).
Job consists of the following components:
tFileInputExcel --> tMap --> tMysqlOutput.
Current speed is 1 row per second which is totally un-acceptable. I need to load files with tens of thousands of rows.
Thank you for your help!
Peter.
Community Manager

Re: Job Performance tuning

Hi
It is unacceptable speed, try to use a tLogRow or tFileOutputDelimited replace tMysqlOutput and check if it is db connection problem. If not, export the job and reinstall TOS, test again.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads