topic Re: Speed comparison between TOS 6.5 and TS 6.3.1 in Talend Studio

Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Sat, 16 Nov 2024 08:27:08 GMT

Dear all,

I face huge performance issues between Talend open studio 6.5 and Talend studio 6.3.1.

I have created the exact same job in both studio's (on same machine). This job contains a tmssqlinput and a tmssqloutput and linked together.

(Just to test 1 table). This table contains 11772873 rows.

With the Talend Open Studio I get 4200 rows/sec ~47 mins

With the Talend Studio (Licensed) I get 66 rows/sec ~3000 mins

It looks like the tmssqloutput is the culprit here, because a tFileOutput is extremely fast in both situations.

Because the Talend studio 6.3.1 is licensed, I would like to have the same speed in this version as the version of the Open studio. What can I do?

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Sat, 07 Apr 2018 10:16:06 GMT

Anyone?

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Mon, 09 Apr 2018 09:11:40 GMT

Hello,

Are your TOS 6.5 and TIS 6.3.1 running on the same machine? How many GB RAM do you have?

Best regards

Sabrina

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Mon, 09 Apr 2018 09:13:20 GMT

Yes, they are running on the exact same machine. My machine has 16 GB of RAM.

This is my INI file:

-vmargs
-Xms1024m
-Xmx4096m
-XX:MaxPermSize=512m
-Dfile.encoding=UTF-8
-Dosgi.requiredJavaVersion=1.8
-XX:+UseG1GC
-XX:+UseStringDeduplication

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Tue, 10 Apr 2018 04:04:25 GMT

Hello,

Have you tried to allocate more memory to TIS V 6.3.1 to improve its performance?

Here is a KB article about:https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/ta-p/21642

Let us know if it is OK with you.

Best regards

Sabrina

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Tue, 10 Apr 2018 08:45:01 GMT

You didn't read my previous post? Anyway, I have tried even below settings without success:

-vmargs
-Xms2048m
-Xmx8192m
-XX:MaxPermSize=512m
-Dfile.encoding=UTF-8

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Thu, 12 Apr 2018 08:20:25 GMT

Hello,

Are you using a 30-day free trial of talend data integration V 6.3.1?

Best regards

Sabrina

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Fri, 13 Apr 2018 08:53:49 GMT

No, I have a 30 day free trial for TOS 6.5.

The TS 6.3.1 is licensed over TAC.

We are currently unable to upgrade from 6.3.1 to somethine higher unfortunatly.

Re: Speed comparison between TOS 6.5 and TS 6.3.1

Anonymous — Tue, 17 Apr 2018 08:23:33 GMT

Hello,

A 30- day free trial for Talend Data Integration V 6.5 is subscription solution without server part(TAC, AMC...)

Are you able to create a case on talend support portal for your licensed V 6.3.1? In this way, we can schedule a webex session with you.

Best regards

Sabrina