Best way to load Data

(0) Share

Report

Posted on by yukonn

227

Hi,

I'm making App with OData. My App consume the OData and show on App. I have 120K items in my item tables. I need to wait so long, after that "function call exceed the time out of 90 sec". So i limited the rows 120K to 10K on my OData services. But i still need to wait 2min plus if i use cable or wifi. It's not good enough for user. You all know most of mobile app is load some data to app at first time and then they load next records if user scroll the grid. My idea is i want to load 100 records on first loading and continue to load 100 records when user scroll the Gallery. I don't see any way to detect the scrolling event on apps. I don't want to put the button and fetching next records.

I hope someone can give me good suggestion.

Regards,

Yukon

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

hngdev 304 on at

Like (2)

Report

I used to have the same issue.
The problem here is the more records you load into the gallery, the more binding processes take place, the more memory used up, the longer to load the app.
What I did was I tried to add some filters (checkboxes, datepicker, etc.) to filter data, also, I add a button with coordinate (x,y) of the gallery so that when the user clicks the button, it will load one other set of data. This helps me to reduce loading time and memory usage.
As far as I notice, the more bindings (could be the more controllers, screens), the more memory usage.

Was this reply helpful? Yes No
yukonn 227 on at

Like (2)

Report

Hi,

I agree with you. Most of apps no longer to use move next, previous button on apps. We will face search function problem if we use move next or previous. Or we need to do more work for this. Now, i get time out error when i load max record.

As far as I notice, the more bindings (could be the more controllers, screens), the more memory usage.

Sure, my app consume 2GB when i open the app.

Regards,
Yukon

Was this reply helpful? Yes No
hngdev 304 on at

Like (4)

Report

This is something that PowerApps team should be looking at because PowerApps is created to build Business app therefore, a huge data source is inevitable.
And I think the more customizable the studio is, the better. I believe this is something that the team already thought of and could do, however, by doing that, it goes against the idea when they build the app that is build app without code.

Was this reply helpful? Yes No