Closed Bug 952202 Opened 11 years ago Closed 7 years ago

pre-calculate "rank" for each product+version+signature combination

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED INVALID

People

(Reporter: rhelmer, Unassigned)

References

Details

A very nice fix for bug 952199 would be to pre-calculate and store the ranking that the tcbs service does here, in a matview for example: https://github.com/mozilla/socorro/blob/master/socorro/external/postgresql/tcbs.py#L70 This would need to be done for each product+version+signature combination, and would improve performance of the topcrasher page as well as the new topcrasher_ranks_bybug report (and anywhere else that this service is used)
I'll investigate
Assignee: nobody → rhelmer
Status: NEW → ASSIGNED
Not working on this right now.
Assignee: rhelmer → nobody
Status: ASSIGNED → NEW
Top Crashers is now entirely re-written to be based on SuperSearch. The only, tcbs postgres based on is decommissioned.
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.