In one of my app I have to allow user to load CSV (can be anywhere between 100-100k rows) and load it to the table in HANA ... doing some transformation in node/xsjs/sql.
UI5 part is relatively simple as it's just oModel.create ....
The problem comes with oData service itself. When I call oData (create) I am executing some SQL procedure that has some logic and inserts data into a table, what is weird for me is -> this is happening "one by one" instead of simple batch loading.
Which basically means that there is only one active statement that calls the procedure, it waits for finish and repeat it for another row. Is there any way to speed it up for example by calling this procedure X times in parallel ? (I know i could sent CSV file but I will have exactly the same problem for another data set where CSV sending won't be possible).
Procedure itself takes ~20MS but sending 1k rows is taking 45sec at this moment...
Would be very grateful for any tips :)