Hi,
I am generating a JSON as a Media Resource GET handler.
The GET handler use a function to get already created JSON from DB . It is written like below:
SELECT 'application/json',get_json_db FROM DUAL;
When i run this SQL in SQL Developer it takes 400 ms. However when the API endpoint is called by client or from POSTMAN it takes around 3.7 secs to receive the JSON.
What measures can be taken to improve the ORDS performance as the query is fine and as already JSON is generated so ORDS should not be doing any more JSON processing.? - please suggest.
Thanks,
A