How do i trace a cap app where the time is sink

[jung-thomas]

@albertlast
about performance how do i trace a cap app where the time is sink? is the business logic the elephant in the room or is the cds/db modell a bottleneck, how do i know what sql command got sended to the db that i could run a vizplan on this?

[jung-thomas]

Specifically to your question of the SQL Command if you set the DEBUG env, CDS will output the generated SQL to the console. There is even a nice, recent blog on this topic: https://blogs.sap.com/2020/06/04/debug-generated-sql-by-cap-framework/ and @qmacro covered this some months back in his live stream as well:
https://blogs.sap.com/2019/10/22/annotated-links-episode-40-of-hands-on-sap-dev-with-qmacro/#debug