Created Myself A Blocking Issue (Tables/Repeating Panels)

[serpenttracker]

So now that I have my importer working and like 20+ snakes I realized I screwed up how I wrote my code for loading my snakes page. Basically I had a card list view or table view that I populated from reading data from the table but that is taking forever.

I guess now I need to switch this to a background task that maybe refreshes the page somehow after the data is loaded in or something? Curious how others have approached this.

[campopianoa]

Please see these posts that discuss optimizing performance in various ways.

Suggestions to optimize performance

Very likely these two posts describes what you need: Here are other posts that talk about client-server communication optimization. EDIT @shaun and @bridget, I listed only my posts because those are the ones I know, but it would be nice to have a few posts organized by topic (performance, data tables, DataGrid, javascript, custom components, etc.) listing the best posts about each topic. These should be maintained as Anvil grows and they get stale.

[serpenttracker]

Ok thanks I think in this case I just need to probably look at pagination options and only pulling so many records at time. I’ll take a look at each of these threads.

Thanks

[campopianoa]

Yes. Please have a look as there are lots of good tips. You can also search for “pagination” if you don’t see it in those posts. For example:

How to quickly get to the last page in a DataGrid

The DataGrid pagination only works with small lists. When I work with larger lists I use a repeating panel. But if the DataGrid is almost good for you and you just want to make the user feel it a little snappier, you can use two server calls, the first one that loads only enough rows for the first page, followed by a self.timer1.interval = 0.01. Then, after the UI has finished rendering the first page, the tick event of the timer will load the remaining rows with another call. It is not going…

[serpenttracker]

do you think something like me running a redis service and using that to cache some stuff could be a potential option as well?

Just thinking how I would normally do something like this in a typical app as well.

[serpenttracker]

Also looks like what was breaking this wasn’t the pagination thing, but the fact I was generating a individual snake form and setting up a hyperlink in the table. Once I removed this for now and went back to a normal datagrid with repeating panels its super fast now.

So I’ll just have to revisit the code on creating hyperlinks to click on the snake name to get to “its page”.

Thanks @alcampopiano