Skip to Content
author's profile photo Former Member
Former Member

Performance testing for Hana

Hello,

I am new to SAP Hana. I am trying to do a performance test for my analytical view for which I have some 100k records with two calculated columns. I simply want to see how long a query of all the data will take to return.

How do I view this information?

Thank you for your time!

Taylor

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Dec 04, 2014 at 05:28 PM

    Hi Taylor,

    Whenever you execute a query in HANA Studio (SQL Editor) it will display in the execution and fetch time for the query in the output panel (white thing below the result set panel).

    Of course, HANA Studio has a standard fetching limit (1000 rows). You can change that in Menu Window -> Preferences -> SAP HANA -> Runtime -> Result.

    Best Regards,

    Lucas de Oliveira

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 13, 2014 at 06:08 PM

    Hi Taylor,

    You can enclose your select inside SELECT COUNT(*) FROM ( <yoursqlgoeshere> );

    And pay attention to time spent on server only.

    There are two others times that may confuse you processing time (plus network) and fetch time that with count will be very small.

    Regards, Fernando Da Rós

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 13, 2014 at 07:06 PM

    The plan visualization (PlanViz) would be the tool of choice here as it actually fetches the complete result set.

    SAP HANA performance is tremendously affected by the size of the result set - so simply doing a count or just fetching 1000 rows won't give you a realistic answer.

    @Fernando Ros: the optimizer of most databases is now clever enough to find out if you are just counting and will change the execution accordingly. For SAP HANA this means: we just skip materialization wherever we can - which leads to very different results for the runtime on count(*) and the actual SQL command.

    - Lars

    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.