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?
Are your TOS 6.5 and TIS 6.3.1 running on the same machine? How many GB RAM do you have?
Yes, they are running on the exact same machine. My machine has 16 GB of RAM.
This is my INI file:
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/...
Let us know if it is OK with you.
You didn't read my previous post? Anyway, I have tried even below settings without success:
Are you using a 30-day free trial of talend data integration V 6.3.1?
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.
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.