Six Stars

Slow execution of talend job

How to speed up the execution time of talend job? Currently the below flow is taking more than 20min. Please suggest.

 

MSSQLInput-->tMap-->OutputExcel

 

Note: Excel has macros/formula in more than 10 sheets.

Tags (1)
1 REPLY
Six Stars

Re: Slow execution of talend job

Hi Syed,

 

Usually writing data to Excel with multiple sheets will take time as creating new sheet will actually recreate the complete excel per every new sheet, some time job will fail as well, if the excel has more tabs, break it in to multiple excel books, 

 

EX: Excel Book 1 with Sheet A,b,c,d,e,f,g,h,i. you can create Excel Book 1 with Sheets a,b,c and Excel Book 2 with sheets d,e,f and Excel book 3 with sheets g,h,i based on your data volume.    

 

Thanks

Ashok