https://bugzilla.wikimedia.org/show_bug.cgi?id=42299
Web browser: ---
Bug #: 42299
Summary: use aggregate data rather than individual
contributions
Product: MediaWiki extensions
Version: master
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: ContributionReporting
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Classification: Unclassified
Mobile Platform: ---
It's horribly inefficient to rebuild the reporting from individual
contributions. It's also pointless to ever rebuild in real-time (triggered by
expired cache).
Instead, I propose aggregating from a cron job, or in the db trigger -- a
trigger on public_reporting could update public_reporting_days, along these
lines:
new_total = cur_total + amount;
new_number = cur_number + 1;
new_average = (cur_average * cur_number + amount) / new_number;
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
