cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnP
Kudo Kingpin
Kudo Kingpin

CDS poor performance

We converted one app to load/save data from/to CDS instead of SharePoint lists. To our amazement the performance dropped 2-5x and sometimes even worse. Some screens have "infinite" loading times (dots scrolling in the upper screen non-stop) and saving forms take 2-5x as long. CDS should be inherently faster (database infrastructure), but it seems like a disaster so far in our project.

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User
Super User

Hi @JohnP,

 

Sorry to hear that. CDS is a SaaS and DaaS (dev as a service) and therefore not direct database access and equivalent DB performance. Transactions will be passing through hoops of layers. The performance should be reasonable though, and I haven't gotten any major issues with many of my large-scaled implementations. Here are a few things you can try:

 

  1. Check that the CDS environment is provisioned in the closest region
  2. Try running to diagnostic tool to see perhaps where some of the issues are: 
    https://<crmorgname.crm>.dynamics.com/tools/diagnostics/diag.aspx
    More info: https://docs.microsoft.com/en-us/power-platform/admin/verify-network-capacity-throughput-clients
  3. Refer to the best practices to ensure some configurations/customizations do not impact performance:
    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/best-practices...
    Note: even though is mentions "on-premise" the same applies for online
  4. There used to be no performance differences between a Sandbox and Production environment, but it is no longer the case. Configure your environment to Production type of instance and test?
  5. Try opening a Support Request at Microsoft via the Power Platform admin center portal:
    https://admin.powerplatform.microsoft.com/support

 

Hope this helps!

View solution in original post

1 REPLY 1
EricRegnier
Super User
Super User

Hi @JohnP,

 

Sorry to hear that. CDS is a SaaS and DaaS (dev as a service) and therefore not direct database access and equivalent DB performance. Transactions will be passing through hoops of layers. The performance should be reasonable though, and I haven't gotten any major issues with many of my large-scaled implementations. Here are a few things you can try:

 

  1. Check that the CDS environment is provisioned in the closest region
  2. Try running to diagnostic tool to see perhaps where some of the issues are: 
    https://<crmorgname.crm>.dynamics.com/tools/diagnostics/diag.aspx
    More info: https://docs.microsoft.com/en-us/power-platform/admin/verify-network-capacity-throughput-clients
  3. Refer to the best practices to ensure some configurations/customizations do not impact performance:
    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/best-practices...
    Note: even though is mentions "on-premise" the same applies for online
  4. There used to be no performance differences between a Sandbox and Production environment, but it is no longer the case. Configure your environment to Production type of instance and test?
  5. Try opening a Support Request at Microsoft via the Power Platform admin center portal:
    https://admin.powerplatform.microsoft.com/support

 

Hope this helps!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Users online (1,908)