[HELP] SLOW PERFORMANCE ISSUE

[YamiteKudasai]

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?

[Pstork1 · Accepted solution]

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.

[BCLS776]

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

Bryan

[YamiteKudasai]

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

[Pstork1]

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.