Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / How to improve D365 On...
Dynamics 365 general forum

How to improve D365 Online data processing performance?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We have many records which must be bulk imported to CRM and exported to other Thrid Party environment with plugin and API. Typically, more than 5K to 6K pieces of data need to be processed at one time.

We've already split the data into 100 records at a time while sometimes we still get the SQL Time Out Error when the response is longer than 2 minutes. Is there any other way or paid way to improve the response performance and data processing function. We are using Online environment. 

Thanks in advance.

Categories:
Performance
Integration with Other Products
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to improve D365 Online data processing performance?

    Hi Ravi & Johnny

    Much appreciate for your suggestion.

  • Verified answer
    Johnny Gong Profile Picture
    Johnny Gong 6,482 on at
    RE: How to improve D365 Online data processing performance?

    Hi Partner,

    I don't think there's any way to improve the SQL data processing performance of D365 Online as the Organization Data Center is clustered by region .You could not improve the specified one.

    While I think if you could optimize your coding or refer to the following article to battle such performance issues:

    journeyintocrm.com/.../1715

    journeyintocrm.com/.../1758

    Hope the above suggestion would help.

    Regards

    Johnny

  • Verified answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: How to improve D365 Online data processing performance?

    Hi,

    importing data using plugin is not a good idea. I am surprised to see that you are able to insert 100 record within 2 minutes. This 2 minute limitation cannot be bypassed as this is the online limitation. I would recommended to find some alternate way of inserting data like scribe/ Kingsway soft SSIS etc.

    Hope this helps.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans