Calling same rest api multiple times (in parallel or asynchronously) but response time varies

[Former Member]

Dear All,

I have a Webi report to which i can pass a KPI(a prompt) and it generates a report specific to KPI value passed.

I will be passing 7 different KPI values and therefore it generates 7 different reports from the same webi report(say template).

I am using Rest API to achieve this. Below are the steps:

1. Refresh document by passing KPI parameter value.

2. Export the refreshed Report.

3. Do step 1 & 2 for all the KPI values.

4. Finally merge all the reports into single pdf file using custom .Net solution.

I am able to achieve all this and it is working fine.

Now , I want to trigger the rest api calls concurrently to improve performance instead of sequential.

When i make ajax(asynchronous) calls, all the REST API calls are triggered at the same time but from network trace (as shown in below) it shows different response times (min=30sec and Max=1.3 min/1.5min).

For troubleshooting, i made all the REST API calls same (passing same KPI) but unfortunately the response time is significantly different.

Also i noticed, that after six concurrent calls, seventh call is triggered late i.e it is stalled (i.e. call is triggered after some time.)

Could any one explain this behavior or if there is a configuration i need to change in CMC ?