cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbouchami
New Member

Performance on canvas using Sql server with on premises data gateway

Hello,

I'm developing a canvas app using canvas with SQL on premises data gateway with large set of data 2k+), and i am facing latency and performance drop on other users but not on my side. they have reported that the app is acting normal at first and then when they use it for more period of time it starts to act wrong, the app is fetching wrong data, and it became too slow.

I am on 16GB ram pc and i used the monitoring tools and task management on Firefox and chrome to see if there is something wrong on the app, and there is nothing alarming, the app is behaving normal.

Other users are on 5 to 8 GB ram pc on Firefox and they are reporting issues.


Regards

1 REPLY 1
Nogueira1306
Super User
Super User

The problem is not your RAM or your pc.. It is realy the amount of data... My advice would be for you to make really good filters, only use what you really need and remove what you dont need.
Even if you dont use a certain screen or datasource, Pwoer Apps will still load it and that will afect your performance.
Try to filter the datasource, for example, if it is a time app where users insert their timers tou could show only the itens created by the user

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,126)