SAP CDS view查询的fixed limit

知识共享许可协议

版权声明：署名，允许他人基于本文进行创作，且必须基于与原先许可协议相同的许可协议分发本文 （Creative Commons）

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.

clipboard4

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

clipboard6

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)]