Page MenuHomePhabricator

slow report result and report list fetching
Closed, DeclinedPublic

Description

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).


Version: unspecified
Severity: normal

Details

Reference
bz71603

Related Objects

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:59 AM
bzimport set Reference to bz71603.
bzimport added a subscriber: Unknown Object (MLST).
QChris removed a subscriber: QChris.Mar 23 2015, 1:20 AM
Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald TranscriptNov 29 2015, 2:06 PM
mforns closed this task as Declined.Mar 26 2019, 3:09 PM
mforns added a subscriber: mforns.

Declining because Wikimetrics is being discontinued. See: T211835.

Restricted Application added a project: Analytics. · View Herald TranscriptMar 26 2019, 3:09 PM