Unanswered

[HELP] SLOW PERFORMANCE ISSUE

(0) Share

Report

Posted on by YamiteKudasai

195

Hello Everyone,

Good day!

I have a collection with 1400+ rows from a data source and the retrieval of data from SP List as data source to collection was executed during on start of the app. However, this is affecting the performance which slows like 1-2 mins and for other users 3-5 mins.

1400 data is important for me because the data is used for other filtering.

Question:
Is there any other way to improve the loading of the app to less than a minute? Any suggestions on how to improve?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Pstork1 68,678 Most Valuable Professional on at

Like (2)

Report

Re: [HELP] SLOW PERFORMANCE ISSUE

The way to improve the performance is to use the data source in place instead of loading it into a local collection. Loading large amounts of data into a local collection will always be a performance drain and should be avoided as anything other than a last resort.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

Re: [HELP] SLOW PERFORMANCE ISSUE

First question is: do you need to load this collection? And, are you loading all columns into it?

Bryan

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

Re: [HELP] SLOW PERFORMANCE ISSUE

Yes @BCLS776 , I really need to load this collection and also a yes I'm loading all columns from data source.

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: [HELP] SLOW PERFORMANCE ISSUE

The question is WHY do you feel you need to load the local collection? Its almost never necessary and almost always leads to poor performance and data conflicts. I repeat my answer. The fix is to stop using the local collection, not look for ways to minimally tweak its performance.

Was this reply helpful? Yes No