topic Webservice timeout:Restful service in Talend Studio

Webservice timeout:Restful service

Anonymous — Sat, 16 Nov 2024 09:40:58 GMT

Hi,

A talend job to provide data provisioning using webservice has been created i.e extracting the data from database and transforming it in form of xml
The sequence of components used is
tRESTRequest--main-->TflowToIterate--main-->toracleInput--main-->tXMLMap--main-->tRESTResponse

Following job works fine but due to huge data i.e 1 million rows there is timeout while accessing the webservice.Also there is join query in toracleinput.
1. How can we perform performance tunning?
2. How can the response time be reduced in above case without increasing the timeout duration above 180 sec

Regards,
Gaurav

Re: Webservice timeout:Restful service

TRF — Mon, 05 Jun 2017 22:18:01 GMT

Is your SQL query fully optimized?
How long before to receive the result when using SQL*Plus? (you cannot expect a better response time as soon as use the same query with the same condition)

Re: Webservice timeout:Restful service

Anonymous — Wed, 07 Jun 2017 12:17:08 GMT

The query involves fetching the data from a view

I have checked the response time at various stages.Following is result

Time taken for Executing Query on view using TOAD for Oracle : 34 sec

Total Execution time (checked in Talend developer studio) : 280 sec

The same query and same condition has been used while calculating response time