none
CRM - Best practices or configuration RRS feed

  • Question

  • Hi CRM Gurus

    We are using CRM adatper to send data to CRM system, but there is lot of amount of data to send, more than 1 million records. Data is passing through successfully, but it is kind of slow.
    I was looking for any configuration parameters of CRM adapter, I can see only default Batch size of 20, changed it to 200, but not much of difference in speed.
    Are there any configuration parameters to work with ?

    Thanks
    Kishore

    Monday, January 24, 2011 5:26 AM

Answers

  • I know this will sound bad, but I would upgrade to CRM 2011. The new adapter use is over the WCF adapters and even a REST interface. I think the performance would be much better. The CRM 4 adapter relied on MSMQ which is disconnected and slower.

    Since you cannot have 2 instances of the CRM 4 adapter running at one time you could not scale it vertically to match the load and this is a big problem.

    The bulk import tool outside of BizTalk would be more helpful for initial data loads: http://msdn.microsoft.com/en-us/library/bb291036.aspx.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Monday, January 24, 2011 6:57 PM
    Moderator