When using DSS REST API in terms of performance (speed of extraction) is there any known/expected difference between using an 'On Demand' (data returned in response) and 'Schedule' ('physical')? In summary the question is, does one method return the data more efficiently than the other?
I do not see any reason why a scheduled or On Demand request would have different performance. My reasoning is that the main time consumer is the data extraction process itself, not the way it was triggered.
It is true that scheduled requests are triggered directly by the server, whereas On Demand requests are queued, and if the queue is very busy, there might be a delay before the extraction starts. But how meaningful is that delay, statistically, how does it compare to the extraction time ? Note also that if you have to create an instrument list, template and schedule, those 3 steps also take time … compared to a single On Demand request.
My choice between scheduled and On Demand would be based on the workflow and use case, not on a performance consideration, but that’s just an opinion.
As Zoya mentioned, extraction times vary, based on a whole set of factors, like server load.
That said, if you observe occasional cases where the extraction time is significantly higher compared to usual values, there are several things you can do to understand why it drops:
No. This should not be happening. So please use the way to request that you prefer.
What you should expect to see, is that processing time may vary. The exact same request is not getting the exact same processing time on different days, and at different times of the day.