Transmission is very slow

Eight Stars

Transmission is very slow

I am pulling data from database and storing it in Excel. This output excel is having some formulas in it. The transmission is taking so much of time to complete (more than 30 min to complete the transmission). Please suggest how to make the transmission faster. When i tried to load in normal excel with multiple sheets, it transmits fast. But when i use this attached excel which has formulas then the transmission is slow. Is it the issue with excel? Or is there any solution in talend to increase the speed?


Re: Transmission is very slow


Would you mind showing us your formula cells? Does it works fast when you use t<DB>Input-->tLogrow without excel output component in your work flow?

Best regards




Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Eight Stars

Re: Transmission is very slow

When i use normal excel without any formula or tLogrow, it works fast. 


Only the excel with attached formula is taking so much of time.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

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