You’re offline. This is a read only version of the page.
281
I've built an app using dataverse and unfortunately it is quite slow.
Are there any tips on how to speed it up?
The app is used to submit scores against a number of items once a month.
there are approximately 20 sites, each having 400 rows in the items table, and each months all 400 rows are given a score (submissions table).
the app is broken down into a number of screens,
screen 1,
user selects the site they want to enter scores for
the next screen they see a list of all items for that site (items in green). Max 400 rows.
Share
ReportUpdateContext({loadStatus: "Collecting Items"});
ClearCollect(col_PMMS_Site_Items, homeGallery.Selected.Items);
UpdateContext({loadStatus: "Collecting Submissions"});
ClearCollect(col_PMMS_Submissions, Filter(homeGallery.Selected.Submissions,Month=monthCounter1,Year=yearCounter1));
They then click into one of the rows which opens a form to allow a score to be saved
the save button has
SubmitForm(ScoreForm);
ClearCollect(col_PMMS_Submissions,Filter(Submissions,cr20b_month=monthCounter1,cr20b_year=yearCounter1));
Saving is quite slow as I have to clearcollect the Submissions each time, otherwise the updated score isn't shown in the table.
How can I make this faster?
@nick9one1 wrote:
Saving is quite slow as I have to clearcollect the Submissions each time, otherwise the updated score isn't shown in the table.
How can I make this faster?
@nick9one1, sorry but I don't understand your use case. So, the slow saving is because you have to save one item at a time? Do you need to bulk update/save?
Hello, @nick9one1, are you updating 400 records at once for each site?
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
All responses (
Answers (
