Answered by:
batch processing of ownership

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 PMModerator
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 PMModerator -
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
- Proposed as answer by Gonzalo Ruiz RModerator Monday, June 6, 2011 3:05 PM
Monday, June 6, 2011 3:05 PMModerator -
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