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
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)
