Slow performance on composite provider

[Former Member]

Hi folks,

We are encountering performance issues on BW queries on top of a composite provider involving ADSO with large amount of data : runtime about 20 seconds

If I recreate the query on top of an openods view, I have no performance issue : runtime about 1 second

Hope someone can help

[Former Member]

Hi Christophe,

Have you checked note 2103032 - Long runtimes in query on CompositeProvider?

Kind regards,

Andrey

[Former Member]

Hi;

In RSRT execute with debug and flag "Display statistics data".

Here you will be able to trace where the performance is not so good.

Hope it helps;

Regards