We are facing a issue with slowness in response when calling novacura using web link(API call). The flow is not complicated just running one query against the database (using a machine step) and result is list of json objects. when we run query in the database directly it takes 20 seconds but when i use postman and do the call it takes around 7 mins.
A simple web search said ”data is passing through novacura middleware server → IFS middleware server → oracle database, once result returns from database it should passthrough the same path and then packed as JSON objects at NOVACURA and then passed as result."
is there anything we can do to improve the response time?
Thank you for the quick response. i have run the same setup from my local machine today, which has a VPN connection to the corporate network. i noticed a reduction in time with no change in the code. FYI. This is earlier than usual working hours for me, also most of the sites are not operational, so corporate network is not fully utilized. let me know if you need more information.
PL/SQL developer client - 67 seconds (if run from local network of database server around 20 secs)
NOVACURA flow classic (using same workflow with play button) - 3minutes 20 seconds
POSTMAN - 4 minutes (previously noticed during peak hours around 7 mins)
Is the PL/SQL tool installed locally on your PC? And you are running the exact same query (character by character) inside only one machine step against the same database? And not using the iterator or anything like that in the machine step. Perhaps some screenshots to help us understand the setup?
And can you explain how you use Postman? Have you created an API against the DB, or are you using IFS OData or something? I guess the back-end SQL query might be built a little differently, and if nothing else, executed on a server closer to the Oracle server?
yes PL/SQL tool is installed locally on your PC (postman, novacura classic, all tools are installed locally) and running the exact same query (copy paste). i have attached some images on postman and web URL(API) please check.
Hi, The connector, it is not directly against Oracle if I read it correctly, but via IFS Application layer? On the connector, it is the IFS Application layers url right, not the oracle server?
I think that might explain the difference.
I like how use use Flow as the API layer for postman . But my guess is that the bottleneck is the application layer of IFS. Do you happen to have a Oracle connector set up against the DB?
. But my guess is that the bottleneck is the application layer of IFS. Do you happen to have a Oracle connector set up against the DB?