web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to Improve CRM Bul...
Microsoft Dynamics CRM (Archived)

How to Improve CRM Bulk Creation Performance in Dynamics 365 Online ?

(0) ShareShare
ReportReport
Posted on by Ramakanta 2,715

Hello All,

              I am working on a requirement where i am creating more than 10,000 orders with more than 1,00,000 associated order product.I am creating order and order product in a single service call  as described in http://missdynamicscrm.blogspot.com/2015/05/tips-crm-c-create-validated-parent-child-records-as-big-compound-using-relationship-related-entities-object-c-sharp.html ,i am using Excutemultiple Request to create the order with order product  but its taking hours to create the order and order product.Sometimes it is giving Timeout error when an order contains more than 15 order product .I also tried to create order 1st and then order product but it also taking similar time.Can anyone please help me how can we improve the performance ? 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hey, for my project (visit my website for details) I used advice from https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/org-service/use-executemultiple-improve-performance-bulk-data-load. Hope it helps

  • Suggested answer
    Ben Thompson Profile Picture
    Ben Thompson 6,350 on at

    Sadly you can't. Adding lines to an opportunity, quote, order or invoice is one of the most process intensive processes within Dynamics 365 as each order line requires the rest of the opportunity / quote / order / invoice to be recalculated and refreshed.

    My advice would be to batch things into small batches of less than 100 orders or 1000 order lines in each executemultiple request (whichever limit you hit first) and accept it will take some time and to ensure that each batch contains all the order details.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans