more then 10K rows need to insert in SQL everytime by SAP MII

[ankit12]

Hi Experts,

we are having a requirement where we need to refresh data into the data into the table at certain time interval and data is huge in number (~20K) record each time.

we have tried to insert data into table using Repeater and it takes around ~1 hour to insert 10K records into the SQL table so checking if there is any other way where we can achieve it in optimized time.

Any suggestion on this requirement will be helpful.

Regards,

Ankit Gupta

[agentry_src]

Hi Ankit, You might want to provide a bit more information on your issue.

• What is the source of the data?
• How big are the records (number of fields)?
• What database vendor?
• Do you have indices for the table?
• Have you had your DBAs look at your table and insert queries?
• If you are downloading from SAP, why not establish change pointers which only provide the data when it changes (in specific ways), is created, or deleted.

Regards, Mike

[ankit12]

Hi Mike,

Thanks for your response.

• What is the source of the data? --> SAP Inventory table.
• How big are the records (number of fields)? --> 9 field need to update.
• What database vendor? -->SQL server.
• Do you have indices for the table? --> No
• Have you had your DBAs look at your table and insert queries? --> No
• If you are downloading from SAP, why not establish change pointers which only provide the data when it changes (in specific ways), is created, or deleted. --> as this need to update on regular interval to update inventory from SAP to SQL side.

[steve_stubbs]

Hi Ankit,

You may want to set this up as a stored procedure in SQL Server and call the stored proc from MII. There you can use either Select Into or a Cursor to perform the selects and inserts. Performance will be much better as a stored proc.

Regards, Steve