SAP CDS重定向檢視和直接讀這兩者場景的效能比較

注销發表於2019-12-17

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.

SAP CDS重定向檢視和直接讀這兩者場景的效能比較

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

SAP CDS重定向檢視和直接讀這兩者場景的效能比較

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:

SAP CDS重定向檢視和直接讀這兩者場景的效能比較 SAP CDS重定向檢視和直接讀這兩者場景的效能比較

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

SAP CDS重定向檢視和直接讀這兩者場景的效能比較

要獲取更多Jerry的原創文章,請關注公眾號"汪子熙":

SAP CDS重定向檢視和直接讀這兩者場景的效能比較


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24475491/viewspace-2668977/,如需轉載,請註明出處,否則將追究法律責任。

相關文章