首页 > 其他 > 详细

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

时间:2019-12-17 15:39:47      阅读:113      评论:0      收藏:0      [点我收藏+]

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

Comparison scenario

The two below operations are compared:

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

技术分享图片

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

技术分享图片

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:

技术分享图片
技术分享图片

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

技术分享图片

要获取更多Jerry的原创文章,请关注公众号"汪子熙":
技术分享图片

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

原文:https://www.cnblogs.com/sap-jerry/p/12054706.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!