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.
UpdateContext({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?
