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