Performance Analysis of Calculation Views in WebIDE Full-Stack

[andrefernandes]

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é

[lbreddemann]

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.