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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Does a large amount of...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Does a large amount of records affect the performance in the system?

(0) ShareShare
ReportReport
Posted on by EmmaCRMadmin

Hi, 

We are using Dynamic sales today and have been looking in to importing order and order products in to the system every night form our ERP system. I am wondering if it will affect the performance in any way to have a lot of data in the system? it will be created records by a flow during night time so the users wont be affected during the time the records are beeing imported. 

It is about 50.000 orders every week. And will need to be stored at least 2 years.

I have the same question (0)
  • Suggested answer
    Roberto Ilidio Profile Picture
    Roberto Ilidio Microsoft Employee on at

    Hi Emma, 

    Besides the performance, I would like to raise another concern, that maybe is even more relevant, you should take in consideration the cost of storage in Dynamics CE as well.

     

    I would proceed with this data importing only if it is really required to be storage in Dynamics, it means,  if  there is business requirements to manipulate such data inside Dynamics.

     

    If the requirement is only to visualize this data inside Dynamics, you can find other implementations to visualize the data from your ERP in Dynamics Eg.: Virtual Entities

     

    Regarding the performance, in the backend there is a MS SQL server running all the optimization algorithms and techniques of a regular SQL server to improve performance, as cache, index, statistics to optimize execution plans etc. In CRM application side, there is techniques to avoid impact as well, as the pagination of the records in the views, for example. I would not expect a huge impact for the end users, but as any SQL server, more records can always impact the execution time of select and updates operations.

     

    Eventually you can perform tests and open a Support ticket to discuss with Microsoft if you verify a poor performance.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 196 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 129

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans