Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
batch processing of ownership RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Please don't post the same question duplicated: http://social.microsoft.com/Forums/en-US/crm/thread/70cef2a1-5550-4a17-b7e8-006deee6ecb9

    Gonzalo | gonzaloruizcrm.blogspot.com

    Monday, June 6, 2011 3:05 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    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