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:
I am getting an Id from the webservice
I save this id with tjavarow as a context variable to use it later on the sql query.
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!
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to use an API-First Approach to Modernize your Applications
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs