Skip to Content
0
Former Member
Jan 12, 2009 at 09:02 AM

Bulk Insert of data into DB

1932 Views

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