locked
batch processing of ownership RRS feed

  • Question

  • We have a CRM implementation where potentially thousands of records could need their ownership changed.  Using the supported way of changing ownership through the CRM web service, this process can take 20-30 minutes.  The requirement is to have this less than one minute.  We don't want to update the CRM db directly.  Is it possible to change ownership on thousands of records in a performant way?

    We are already running async in a background process.  But the users need near immediate results.

    Monday, June 6, 2011 2:27 PM

Answers

  • You cannot magically make it happen in less than a minute, if you do it synchronously, calling the web services is the best option, otherwise asynchronously but it would take even longer. As you noted, changing in DB is not the correct way because it would bypass all the cascading rules and data integrity can be compromised.

     

    Is there a way you can modify the requirement to allow for more flexibility? Such as doing one business unit at a time, for example.


    Gonzalo | gonzaloruizcrm.blogspot.com

    Monday, June 6, 2011 3:03 PM
    Moderator