Performance Issue

[former_member461591]

Hi Gurus,

I have a four queries each of which supplies data to the next. When I test each query as a stand alone object in a dataflow they each take about 300 seconds to run. When I daisy-chain them in sequence in a single dataflow they take about 7500 seconds. Clearly DS is doing something strange under the hood. Can anyone enlighten me as to the cause of this behavior and how to fix it?

Interestingly I was able to unify them into a single query (an eight table join) and it ran in the same time as the individual queries.

Thanks

Cliff

[former_member187605 · Accepted solution]

Most probably, when you run them separately, DS pushes the logic to the underlying database.; when you chain them together, it doesn't.

See

https://blogs.sap.com/2014/02/13/let-the-database-do-the-hard-work-better-performance-in-sap-data-se... for an explanation of those so-called SQL-pushdown mechanisms.