Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Make a Talend Job Faster

Hi,

 

I have a job which send a response to a webservice, I need this job to be faster. I don't know if I can change some settings to make this possible.

 

This is the job: 

 

0683p000009Lr8D.jpg

 

I am getting an Id from the webservice

 

0683p000009Lr8I.jpg

I save this id with tjavarow as a context variable to use it later on the sql query.

 

0683p000009Lr8N.jpg

 

0683p000009Lr8X.jpg

 

0683p000009Lr7L.jpg

 

I really need to have less microseconds on the response!

If you have some idea I would appreciate it, otherwise I won't be able to use talend to do this webservice!

Labels (3)
1 Reply
TRF
Champion II
Champion II

Hi,

First of all, arrange your design for a better lisibility.

It will not change the response time, but it will simplify your life for the future!

 

It seems, that you use dedicated SQL connections for both tMSSQLInput components.

You should establish 1 connection in a Prejob subjub then, reuse this connection for both tMSSQLInput components.

 

Hope this helps.