Sage CRM

Sage CRM 7.3 - data upload (company) is going really slow. This is a second round of imports and he same data mappings are being used. Any ideas on what is causing the slowness?

Did you leave the parking brake on? If that's not it, check the machine resources. Are you doing it at the server? On a workstation going across a network? How big is the data file? How many records?

Directly on the server. About 4500 records per file - 5 files to import. Did it previously and each file took 10-15 minutes. Then th et realized they had to do some cleanup of their Salesforce data so we wiped data and are doing round 2, but running really slow

Well ... you have records in the system now so all the indexes are doing extra work as you import more records. If anyone is a MS SQL expert, maybe they could advise here? I'm wondering - definitely not recommending it because I don't know enough - if you could turn off the indexing until the records are all imported?

@PeterWolf - is the code that takes the contents of Temp_DUTable and puts it in the company, person,address, etc accessible somewhere? Sage support was no help and leaving it run for several hours only added about 30 records to the company table and I got back to the attached screen shot in the browser.

The upload process does still seem to be running in the background, but at a rate of about 5 minutes per record...

disabling indexes other than PK did not help

I checked with my team and no one had any specific suggestions. Did Sage support offer any clues?

Finally figured out late last night that the delay was that it was looking for the integration engine which was off because I did NOT want anything sent over to MAS, and even though updating MAS from CRM as turned off on the MAS integration side I did not trust it (and it looks like I was right not to). Had to disable the whole integration and will then have to turn it back on again once they confirm this upload is OK.

Thanks for the update!