New Group Reports Page (Read 206 times)

Hi all,

The biggest bottle neck in the system is the group reports page. When you open that page, it tallies all the members' workouts for the specified date range, and then filter them based on various permissions.  When it was first created, I did not anticipate groups with more than a few dozen users.

There are groups in the system with nearly a thousand members.  If you go to one of these groups, the page would take many minutes to generate.  If you include a large date range (months or years), it would take even longer.  Worse still is if several people go to the page at the same time, it may even affect the rest of the website because too much resources are spent in generating the stats.  Many users learned to avoid that page altogether.

I redid the page from scratch, along with all the underlying code.  The new code is much faster when displaying mileage stats.  The load time is equally fast if the time range is a week or 10 years. You can also display stats for bike or swim.  It is not possible to display custom activities because everyone's log is different.

The race page is also redone.  Since it is displaying individual workouts, the search time is still somewhat slow but is within acceptable tolerance.  Most of the columns are now sortable.  You may get some interesting data out depending on how you sort.

Since this page is rewritten from scratch, it is possible that the stats can get out of sync.  Please report any discrepancies you see with your log and the group stats.  Eventually, this code will be used by the summary page so it would also load faster for people with lots of stats widgets.

There is currently one known bug.  Group admins won't be able to see your data if your log is private but you set the group option to allow admins to see your log.  It will be fixed today.

eric

Wow, that's pretty cool! Thanks!

The distance number of many group members is incorrect. The correct distance will be shown only after click the button "displace"

Works fine, Eric. Nice work. 

Eric,

I see the same behavior across groups.  Some examples would be:

Chan and Chaska Track and XC

Holy Family Distance Crew

Northstar Running Club

https://www.runningahead.com/groups/BraamBot/stats

Total for Nate seems off.

https://www.runningahead.com/groups/Chaska_Chan/stats

Total for Kyle seems off.

Hi all,

I've figured out what happened.  When the feature was deployed, I had to update the statistics.  The calculation erroneously included all workouts, including the workouts that were imported but not yet added to the logs, and the workouts that are queued for deletion.  I need to redo the statistics but need to want for quieter hours such as late night during the weekend.

eric

Thanks for fixing the bug. Would you mind to change the default sorting by mileage?

Hi lldyh,

If I make the change, inevitably someone else will ask that I change it back to sort by name.  I won't make the change at this time.  If enough people request the change, then I'll consider it.

eric

Looks like the weekly totals have been fixed.