Unanswered

Needed to Improve App Performance with Large SQL Databases

(0) Share

Report

Posted on by Rajkumar_M

3,741 Super User 2025 Season 2

Hi Everyone,

I have a CRM app that contains more than 30 SQL databases and uses some collections. The app is now loading slowly, so I decided to use Views and Stored Procedures to improve performance, which resulted in only a 40% increase in speed.

Is there any other way to improve loading performance? We have already reduced the number of controls on all screens, but it didn't help.

Can anyone suggest the best way to enhance the app's performance?

Thanks,

Raj.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

Needed to Improve App Performance with Large SQL Databases

Hi

When you say you have CRM app that contains more than 30 SQL databases - are they custom CRM or Dynamics 365 CE/CRM? pls clarify.

thanks

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

Needed to Improve App Performance with Large SQL Databases

Hi @SaiRT14

We developed our own CRM app using a Power Apps Canvas app and used a SQL Database Server as the backend for the app.

Thanks.

Was this reply helpful? Yes No