Performance comparison between Code Pushdown Technique vs Traditional ABAP

[#1]

Hi @everyone,

Case 1 - When we use code pushdown technique and pushed where conditions to CDS along with Parameterized CDS

Case 2 - When we use Parameterized CDS but didn't pushed where conditions to CDS

Case 3 - When we use normal CDS view with pushing where condition to CDS ( All filtering happened on Application layer )

In the above mentioned three cases here are the observations -

• In this scenario I have utilized code pushdown technique and pushed all where condition in CDS and also I am utilizing Parameterized CDS to narrow down data from Database itself but in this scenario when I ran SQL Traces ( Case 1 ) it took more time in execution than the scenario where I just utilized parameterized CDS without any where condition ( Case 2 ) and the fastest execution happened when I utilized normal CDS ( Case 3 )

I have some open question related to CDS performance tuning as below -

1. Is Code pushdown ( with Parameter and where ) slower than application layer filtering
2. if not then how can we decide when to use parameterized CDS or when to use normal
3. is where on CDS taking more time than application layer filtering

Looking forward to get the correct understanding.. @Andre_Fischer , @thomas_jung , @RichHeilman 

Regards,

Harshit

[junwu]

cds is for data modeling

barely for performance boost

can you also share the cds code?