Symptom
You are doing API calls using snapshot-based pagination and sometimes they are resulting in high response times, causing timeouts in your application.
Environment
- SAP SuccessFactors HXM Suite
- OData API
Cause
On the OData guide page we can see the following statement regarding the disadvantages of snapshot pagination:
"Potential first-page timeouts for complex queries. When you execute a query, a snapshot is created during the first page by executing the full query. Therefore, the request of the first page takes longer than subsequent pages. It can lead to potential timeout errors for large data sets with complex filtering, sorting, and expanding options.".
So this would be an expected behavior.
Resolution
It is expected that snapshot-based pagination sometimes result in high response times.
There is currently an enhancement planned for 2H 2021 that should help on reducing this high response time. More information about it will be shared in this KBA once it gets available.
Keywords
API-17666, server side, server-side, performance, slow, response, sf, release , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem