Hi Team,
We have an issue with REST API Call as the app works fine in DEV env and fetches the result successfully. I am calling REST API to fetch the data from Postgres Table and in DEV, only 100s of records in the table so the API returns the results within 10 secs.
I have merged the same app into prod and the REST APP is pointing to prod DB where the numbe of records is more than 1M and the API returns records ~20 secs. I have set the API timedout property to 50 secs but still, the app is timing out after 10 secs.
We have checked the below property in prod and everything looks OK.
DBCONNECTOR_QUERY_TIMEOUT_MS=180000
Timeout on load balancer for prod is 120 seconds
Are we missing any settings here? Why the app is always timing out after 10 secs even though the timedout property set as 50 secs.