952199 - [tracker] topcrasher_ranks_bybug is too slow

Status: RESOLVED WONTFIX

(Socorro :: Webapp, task)

Description

[Robert Helmer [:rhelmer]]

The performance of the topcrasher_ranks_bybug depends greatly on how many product+version combination this signature appears in, because the current implementation pulls a TCBS report for each product+version+signature combination to get the "current rank" (which is relative to these three dimensions)

Some bugs such as https://crash-stats.allizom.org/topcrasher_ranks_bybug/?bug_number=947213 are fairly quick but https://crash-stats.allizom.org/topcrasher_ranks_bybug/?bug_number=711568 for example is pathologically slow.

Comment 1

[Robert Helmer [:rhelmer]]

From measuring locally it looks like the TCBS call (to get "current rank" as mentioned in comment 0) is the problem here, so the fix is either to make that faster or eliminate the need to make this call (or so many of them).

Comment 2

[Robert Kaiser]

It looks to me like we are gathering TCBS for more than the active version set right now, could we reduce to that?

Comment 3

[Robert Helmer [:rhelmer]]

Bug 963236 made this *much* faster, for cases where we already have TCBS cached. Even when it still takes a while, loading that URL again should be very quick.

Comment 4

[Stephen Donner [:stephend] Not actively reading bugmail]

New results are up at http://www.webpagetest.org/result/140129_YQ_130S/ -- first view = ~ 45 seconds, second view = ~ 2; wow, indeed.

Comment 5

[Robert Helmer [:rhelmer]]

Not sure if this report is going to stick around, or if it's still in use - in any case I haven't been working on it.

Comment 6

[[DEACTIVATED] Adrian Gaudebert]

We now have https://mozilla.github.io/bug-signatures-status/