SAP Knowledge Base Article - Public

3079262 - High response time when using snapshot pagination - OData API

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

Product

SAP SuccessFactors HCM Suite all versions