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