Skip to Content

HANA Procedure Compilation is consuming too much time

Oct 20, 2016 at 10:04 PM


avatar image
Former Member

Hi All -

In our scenario, we are calling HANA stored procedure from XSJS. The total time it takes to run the procedure via xsjs is 5 seconds. However if we run the stored procedure directly in HANA studio via a call statement on SQL editor then the total execution time is 2 seconds. On further investigation it showed us that 3 seconds are going everytime in procedure compile time. Even if I run the proc via xsjs immediately but it compiles the procedure everytime and consumes those extra 3 seconds.

Our procedure contains local temp tables and Global temp tables. Takes Table type as input parameter and output parameters.

We are running on SPS10 ( ).

My question now is that why HANA has to compile the procedure code everytime even though there is no change in the code.

Please advise.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers