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:33 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

    • Marked as answer by jeljeljel Monday, June 6, 2011 3:26 PM
    Monday, June 6, 2011 3:04 PM
    Moderator

All replies

  • 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

    • Marked as answer by jeljeljel Monday, June 6, 2011 3:26 PM
    Monday, June 6, 2011 3:04 PM
    Moderator
  • Monday, June 6, 2011 3:05 PM
    Moderator
  • Thanks, that is what I figured.  Just wanted to bounce it off someone else.

    Sorry for the crosspost.  I realized my original post was to the wrong forum, and I didn't see how to change it.

    Monday, June 6, 2011 3:27 PM