SAP CDS重定向视图和直接读这两者场景的性能比较

  • 时间:
  • 浏览:0

(1) table ZCOMM_PRODUCT2

This is a very simple table which has only three fields. All of the fields are mapped from MARA.

The two below operations are compared:



Both table have exactly the same number of entries: 97.144

I create two simple ABAP methods to retrieve data from ZCOMM_PRODUCT and ZCOMM_PRODUCT2:

本文来自云栖社区合作者者伙伴“汪子熙”,了解相关信息都需要关注微信公众号"汪子熙"。

A very rough performance comparison is performed in ER9/001.

(2) table ZCOMM_PRODUCT which is redirected to CDS view ZP_MARA_REDIRECT

And use ST05 to trace the duration of these two kinds of SELECT SQL.

The case for direct read via SELECT SQL: 0.159 second

The case for CDS redirect: 0.247 second