When I use the fixed limit – I hard coded 100 – in the code, the performance in ABAP becomes equal in HANA studio – 2 seconds to finish the query.

[外链图片转存失败(img-QdnMafdc-1563690178506)(https://user-images.githubusercontent.com/5669954/32707987-8472f43c-c862-11e7-8060-dd4e9fdfa6b5.png)]

However in CRM WebUI, this limit is specified by end user, it seems we should not hard code it.

[外链图片转存失败(img-7rJG14CG-1563690178507)(https://user-images.githubusercontent.com/5669954/32707988-84a7444e-c862-11e7-917b-4447990d1e81.png)]

And in S4 Fiori Search, the limit is not used any more.

[外链图片转存失败(img-KxwEPvsc-1563690178507)(https://user-images.githubusercontent.com/5669954/32707989-84da3eee-c862-11e7-8ec1-9b425ee784b4.png)]

When end user clicks search in S4, the total number of found product is displayed and only the first 25 product is returned from backend.

[外链图片转存失败(img-ClZyork0-1563690178508)(https://user-images.githubusercontent.com/5669954/32707992-8541c960-c862-11e7-93ef-ffe7dd002321.png)]

This paging logic could be observed in Chrome:

When end user scrolls to the bottom of search list, another 25 products will be fetched.

[外链图片转存失败(img-GQyWKTuo-1563690178509)(https://user-images.githubusercontent.com/5669954/32707994-862d5254-c862-11e7-9fd9-d99741b64ca0.png)]

[外链图片转存失败(img-aYNagQnL-1563690178510)(https://user-images.githubusercontent.com/5669954/32707995-865feae8-c862-11e7-9ae0-9c40bee1630f.png)]