We are trying to integrate ODK with external application and using the API for the same. Our process is simple- first we are fetching all instances of a particular form and then fetching each instance data through the submission data endpoint
But the issue that we are facing is that it takes too much time for this API call to return a response. It is averaging to about 15 seconds per request. The ODK server is hosted on a windows server with not bad configuration.
Is there any benchmark regarding the speed of the API calls ? In your experience what is the standard time it take for this call to execute? And is there any way to quicken it?
I am just not able to figure out why it is taking 15 seconds to fetch one instance from DB??
Please help. It will be deeply appreciated.