MDM Import load average time

[Former Member]

What is the generally observed MDM import load time through import server for 7.1 ? (assuming that sizing is done as per MDM sizing document)

[Former Member · Accepted solution]

Hi Subin,

Import time would depend upon various factors:

• Number of matching fields used
• Matching fields used are Sort Index Enabled or not
• Number of fields to be imported

• So if you are using only 1 field, then it will be not take much time in matching activity and data would be imported quickly.

• In case of more number of fields in matching, then consequently it will take more time in matching step and hence more time in importing data.

• Similarly if we are using some fields for which Sort Index is not enabled(i.e. not set to Normal in Console) then it will have to search entire repository without any indexing which will lead to much more increase in time for doing the matching step and hence more time will be taken while import of data.

• Also it would depend upon the number of fields you are importing through MDIS for each record. More the number of fields, more time it will take. If you are importing data to qualified tables as well and multiple valued fields as well, then it would also depend upong the Qualified links for each record and the number of multiple values for each multi-valued field.

• One more factor here is that when you are using more than 1 field as matching fields, then matching step time would also depend upon if you are using those fields as combination or single fields only. There would be difference of matching time in each case so which will also decide the total time to import records into MDM.

• Apart from this, there could be some other factors like MDS.ini parameter settings related to import etc.

So you can see that there are many factors affecting the import time through MDIS and it would be difficult to provide some estimate in time dimensions. It would be better to monitor import of records for few days and then generalize it based upon the observations, because import time would be different in different environments(in your scenario and in my scenario or some 3rd person's scenario). I hope this helps you.

Thanks and Regards,

Ankush Bhardwaj