cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Cloud / Hana procedure execution by multiple instances/workers

ghennac
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Colleagues,

I have a procedure which mostly take some entries from a table(built as a queue) and then sends the values as input parameters to a calculation view and the result inserts in a table.
The thing is that the amount of records is huge(hundreds of millions) so i was searching for kind of paralel execution.
With the execute parallel explicit statement in a procedure it wouldn't work, because of concurency, but with multiple procedure runs it works.
Could anyone give me some insights in this direction? how to run multiple times the same proc to improve the processing time? Are there any limitations? Which setting should be changed in hana?


Thank you in advance,

Best regards,

Ghenadie

Accepted Solutions (0)

Answers (0)