App Checker: Correcting Performance Errors

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Okay, this oughta be fun....

I've just about got my first full-fledged database up and running. Now, I'm trying to sweep up behind the elephants.

I've got all this at app start...

Concurrent(ClearCollect(PrkSnpShtCollection,ParkSnapShotDetailList), ClearCollect(ApparatusDtlCollection,ApparatusDetailList), ClearCollect(PrkImgCollection,ParkPicLibrary),ClearCollect(ParkListCollection,ParkList),ClearCollect(ApparatusImageCollection,ApparatusImages),ClearCollect(SFCQsCollection,SFCQsList),ClearCollect(DaystoRenewalCollection,SFCertsQualsTitlesList),ClearCollect(CertsQualsDocumentsCollection,'UploadedCerts&Quals'),ClearCollect(PreFirePlanImageCollection,'Pre-Fire Plan Images'));

Clear(SFPrgrmMmbrsCollection);

Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="AKR"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="IMR"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="MWR"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="NCR"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="NER"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="MWR"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="PWR"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="SER"));
Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="NIFC"));

Everything seems to be working regarding the above, I've just got a handful of resource errors, mainly around the above and showing duplicate data across multiple screens. I have one or two Galleries that appears across several screens. My cut and paste to achieve this goal is apparently not the right method.

Can anyone help me integrate corrective actions for the following:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi,

First Issue:
Would you be able to clarify why you are referencing a gallery on a different screen?

Second issue:
Is there a reason for collecting all the data into the collections and not just leaving it in the connection caches?

Additional note:
Clear(SFPrgrmMmbrsCollection); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="AKR")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="IMR")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="MWR")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="NCR")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="NER")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="MWR")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="PWR")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="SER")); Collect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="NIFC"));
Can be reduced down to:
ClearCollect(SFPrgrmMmbrsCollection,Filter(SFMmbrList,NPSReg="AKR" || NPSReg="IMR" || NPSReg="MWR" || ...));
This would mean there in only one request to the database and not none.

Hope this helps,
Alex

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I made the recommended App Start change. It worked. 👍

First Issue:
Would you be able to clarify why you are referencing a gallery on a different screen?

Because I'm ignorant as all get-out regarding any of this; OJT at its finest. Making it up as I go, with help from folks like you.
What you see is a hodge-podge of questions and answers held together with spit, tape, boogers, and band-aids - Sandlot style.
Please, by all means, feel free to comment, fix, correct as you see fit.

Second issue:
Is there a reason for collecting all the data into the collections and not just leaving it in the connection caches?

The end User wants the template view of the base information (the header and the top one or two Galleries) to be displayed
the same way across ALMOST all pages. My answer was to just cut and paste what I created from screen to screen. Apparently
that is not the appropriate method, because I'm eating out resources this way.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

First Issue:
Without taking a closer look at the app, it would be difficult to say.

Second Issue:
If you only need to show a template view with the first rows, then create a new screen add a table and FirstN to pull in the first couple of rows. This way you are only pulling in a couple of rows and not the whole dataset.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-first-last

Then where you reference the top collections in the on start, I would replace with the connections themselves.

If you have multiple screens which are very similar, you can use context variables and navigation parameters to change the information being displayed.

P.S. If you have a little bit of time, there are a number of good online courses and learning paths on the learning.microsoft.com site which might help you up the learning curve.

Hope this helps,
Alex

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yep; when y'all start talking like this I'm done. Half of what you said makes minimal sense to me.

Which is why I'm on here, trying to learn.

I'm in a Power Apps and SharePoint forums (completely ignorant in both), I've read countless posts, pods, etc., and watched countless videos. Which is why you see what you see and ask inquisitively "...what the heck is going on here?" 🤣🤣🤣

I completely understand that I "don't" understand how to do half of what you just rattled off. Trying to convert from InfoPath to Power Apps and Power BI. Steeeeeep learning curve.

But, I am not deterred. With the help of many I've got a pretty could thing built.

...on we go!

Was this reply helpful? Yes No