on 04-11-2024 2:51 PM
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
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.