https://bugzilla.wikimedia.org/show_bug.cgi?id=71603
Bug ID: 71603
Summary: slow report result and report list fetching
Product: Analytics
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Wikimetrics
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: dandree...@wikimedia.org
CC: bugwatc...@sb-mail.wmflabs.org,
christ...@quelltextlich.at, dandree...@wikimedia.org,
dtarabore...@wikimedia.org, kle...@wikimedia.org,
nu...@wikimedia.org, tneg...@wikimedia.org
Web browser: ---
Mobile Platform: ---
It looks like we need a simple index on the report table, probably on the
user_id column, to speed up two operations that have become slow with the huge
size of the report table:
* fetching the results of a single report
* fetching the list of all reports for a user
Also, we could put in place a regular cleanup of the database that deletes
reports older than 30 days (these are not displayed in the UI anyway). This by
itself would not solve the problem as within 30 days EEVS generates a huge
amount of report records.
Yet another improvement could be a way for the report to clean up records after
itself (for example, it could delete its ValidateReport, AggregateReport,
MultiProjectMetricReport, and MetricReport records if those don't store any
intermediary results - which right now they don't).
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
