Skip to Content
avatar image
Former Member

Slow performance on composite provider

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 04, 2017 at 02:03 PM

    Hi Christophe,

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

    Kind regards,

    Andrey

    Add comment
    10|10000 characters needed characters exceeded