Skip to Content

Performance issues with projection

Hi All,

I have a graphical calculation view which has a projection in it.

The projection has a calculation view inside of it that is also graphical.

This sub view is made of tables and joins to scripted views. This sub view executes in 3 seconds.

But when it is put inside  a projection, the view executes in 17 seconds.

What could be the issue here. I am working on a SP10 system.

Regards,

Shyam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 08, 2016 at 06:42 PM

    Shyam,

    many things can be the issue... does your subview return only a structure with a lot of records? it will depend what happens afterwards with the resultset of the subviwew, for example if you do a join and you do substring on the resultset of your subview, then the view materializes into doing the substring operation for each of the results on the subview.

    things to consider in your subview which you may already have... add filters so you return the smallest number of records. then depending on the output.. what else do you do on your parent view... just to see how else it can be optimized.

    what is the size of your system will also have to do with how long it takes to run.

    if you run a plan visualizer on the parent view you will see how step by step is takes on executing the various nodes. for plan visualizer, run the view on your sql console, highlight it, right click and then visualize plan. hope this helps

    I know this is not a straight up solution but at least something to think about.

    Add comment
    10|10000 characters needed characters exceeded

    • it is very confusing and also at some point you will need to use it just to provide SAP instructions as to where the error is.. however, if you can see the node that is causing the issue maybe you can focus on it and try to optimize it...  I even got a response from a moderator once that the plan visualizer is for advanced users after some point... it gets so deep that a normal developer wouldn't understand.. trust me .. its a headache 😊 good luck