Hey guys i finnally figured out a way to sort my event points into a season championship standings page.
I ended up doing it with groups however the load time is insane and its only for 2 events in the season and assuming it will get much worse. Can anyone take a look and advise.
Example Page:
App Page, Read Only.
Consider setting up your database to track points more efficiently through time, so that you can could just do a search for league players sorted by points.
Need to just have workflows set up to add points to a place in the D.B. every time the player earns points.
That was my original thought to but they make a lot of changes after the first upload of that event and were half way though a season and it bugs out then the championship points are off and they would have to reupload and calculate every previous event. Would be a nightmare.
If thats my only option in the end its what i will probably do, but theres got to be a way to make this page load faster it loads fast is i dont group by and show all the results, but once i add group by it takes 10x as long to load.
Why are you using group by?
Are you saying you are already half way through the season and users have already entered the data? If so, set up the database and then create recursive backend workflows to get the data in the correct places.
If you are worried about creating a problem, don’t worry, your development database is separate from the live version.
its the only way i can figure out how to sort the repeating group by total points. if there is another way that would be great, but otherwise whats the point of groupby? Pretty sure im using it as intended.
True thank you i could do recursive for quick fix.
No i understand the databases and versions are seperate.
