How to compare the performance of SAP CDS redirected view and direct read scenarios

How to compare the performance of SAP CDS redirection view and direct reading of these two scenarios, I believe many inexperienced people are helpless about this, for this reason this article summarizes the causes and solutions of the problem, through this article I hope you can solve this problem.

ER9/001 provides a very rough performance comparison.

compare scenes

Compare the following two operations:

(1) Form ZCOMM_Product 2

This is a very simple table with only three fields. All fields are mapped from MARA.

(2) Table ZCOMM_Product Redirect to CDS View ZP_MARA_Redirect

Both tables have exactly the same number of entries: 97.144

I created two simple ABAP methods to retrieve data from ZCOMM_Product and ZCOMM_Product 2:

And use ST05 to track the duration of both SELECT SQL.

Read directly via SELECT SQL: 0.159 seconds

CD redirection: 0.247 seconds

After reading the above, do you know how to compare the performance of SAP CDS redirection view and direct reading scenario? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!