topic Re: Transmission is very slow in Talend Studio

Transmission is very slow

Anonymous — Tue, 08 May 2018 10:01:36 GMT

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

Anonymous — Wed, 09 May 2018 09:57:55 GMT

Hello,

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

Sabrina

Re: Transmission is very slow

Anonymous — Wed, 09 May 2018 10:30:08 GMT

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.

Graph2.jpg

Re: Transmission is very slow

Anonymous — Thu, 14 Mar 2019 17:37:43 GMT

Hi,
I have the same issue with tFileOutputExcel.
I was using Talend 6.4.1 and the job was running in 2-3 minutes.

Now I've updated to Talend 7.1.1 and immediately the running time jumped to 30 minutes.

The component is having this behavior only when the excel file has formulas that needs to be recalculated.

Please advice how to solve this issue.

Re: Transmission is very slow

Anonymous — Fri, 15 Mar 2019 14:26:18 GMT

@lli ,

Did you try to do the same rules through Talend before loading the excel sheet?

I know that excel rules like graph creation cannot be done through Talend but I would suggest to move any possible computation formulas to Talend itself before loading.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Transmission is very slow

Anonymous — Wed, 03 Apr 2019 14:08:04 GMT

Unfortunately it is not an option. I have 2 sheets that consist only of formulas.
All I need to do is to update the sheet containing the raw data.

Re: Transmission is very slow

akumar2301 — Wed, 03 Apr 2019 14:32:29 GMT

can you please check and confirm what is calculation mode in excel , is it automatic or manual?

If it is automatic, try to change it to manual and let me know if it improve performance.

To switch to manual mode in excel, go to Formula Tab –> Calculation Options –> Manual

Re: Transmission is very slow

Anonymous — Thu, 04 Apr 2019 16:16:07 GMT

I've changed the excel formula calculation to Manual.

In the Talend job: advanced settings, I've unchecked "Recalculate formulas".
Now the job runs in 1 minute.

As I've already mentioned, there was no issue with the previous Talend version that I was using... Runtime was 1 min also with formulas recalculated.
The moment I've switched to 7.1.1, this issue appeared.

I need the formulas to be recalculated as I am sending this report over email to the managers.

Re: Transmission is very slow

Anonymous — Mon, 08 Apr 2019 08:06:12 GMT

Hello,

Could you please open the error log generated automatically by the Studio to see whether you have error stack trace there?

Best regards

Sabrina