Skip to Content
0

Slow performance on composite provider

May 03, 2017 at 09:29 AM

524

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member May 03, 2017 at 09:49 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
May 04, 2017 at 02:03 PM
0

Hi Christophe,

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

Kind regards,

Andrey

Share
10 |10000 characters needed characters left characters exceeded