I'm building an MDM scenario on a small server. It would work fine using let's say, 100 records, however, I loaded 65,000 records and it took like 4 hours to import them all.
I've researching other threads about this topic on SDN and I've learned that I could improve MDM performance by decreasing lookup fields. I did so (I had like 20 lookup fields) and I kinda went faster this time, however, it still takes a long.
Are there another issues I could do for improving performance? maybe less fields, using Batch Import instead of Import GUI etc.
I'm using only text fields (no images, pdf's etc) and MS SQL Server.