Hi all,
I am looking for some ideas for a bulk insert of data into a given database (Oracle in this case). Say we are getting a RFC from SAP which causes MII to insert some 100 rows into a table. What are the alternatives using MII?
A repeater and row by row insert is very slow. One possibiliy may be to dynamically build insert strings in MII into one string variable and then call a query using this variable as SQL statement. I will try this to check if it is faster that the one-row-at-a-time try.
Are there any more ideas to improve performace with MII having to insert many rows?
Michael