Performance comparison between Code Pushdown Technique vs Traditional ABAP

harshb86371 — Sun, 20 Oct 2024 03:40:46 GMT

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 -

Is Code pushdown ( with Parameter and where ) slower than application layer filtering
if not then how can we decide when to use parameterized CDS or when to use normal
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

Re: Performance comparison between Code Pushdown Techniqu...

junwu — Sun, 20 Oct 2024 13:03:21 GMT

cds is for data modeling

barely for performance boost

can you also share the cds code?