Skip to Content

Performance Analysis of Calculation Views in WebIDE Full-Stack

Hi everyone,

We are currently designing calculation views in WebIDE Full-Stack. They use as sources different combination of tables and calculation views. However our performance is nowhere near the "scans of 1 billion rows per second per core and join performance of 10 million rows per second".

Most of the Performance Analysers I saw are only available on HANA Studio, not in WebIDE Full-Stack. In fact, the tools in Full-Stack don't seem to be capable of analyzing the bottlenecks of the queries.

Is there any source material or tool the community recommends for improving the performance of those queries?

Best regards,

André

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 16 at 09:17 AM

    you may want to give the Performance Analysis Guide a go, that covers the main tools for query performance analysis.

    Usually, tools like EXPLAIN PLAN and the PlanViz trace are the weapons of choice with HANA.

    Beyond that, there are several blog posts available from yours truly and others explaining how to use those tools.

    (“planviz” as a search term should bring those up)


    concerning the availability of those tools in WebIDE: there is a Web-Ui for PlanViz but personally I prefer using the Eclipse version (which can read the .PLV files saved with WebIDE),


    finally, the scan/join numbers are obviously hardware and data dependent. If your system is not able to scan reasonably fast, then it may be due to lacking HW performance.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.