Skip to Content
1

HANA Procedure Compilation is consuming too much time

Oct 20, 2016 at 10:04 PM

148

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 (1.00.102.06.1461042750 ).

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