1223424 - Drop ADI count inclusion in the custom graphics report

Status: RESOLVED FIXED

(Socorro :: Webapp, task)

Description

[Peter Bengtsson [:peterbe]]

Turns out, on prod, that trying to do a sub-select on the raw_adi table is far far too expensive. So expensive that the query never completes for any webserver to have patience to wait. 

Removing that part, upon experimentation, seems to yield that we can have it return 383,389 rows of CSV in about 29 seconds.

Comment 1

[Peter Bengtsson [:peterbe]]

Attachment: Link to Github pull-request: https://github.com/mozilla/socorro/pull/3087

Comment 2

[Robert Kaiser]

I think the ADI column never actually worked right in the original CSV files, so there's no need to include values for it now.

Comment 3

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/db97681b60c2eb858e42bd32fb27a5bbc1e17a9c
fixes bug 1223424 - Drop ADI count inclusion in the custom graphics report

https://github.com/mozilla/socorro/commit/ec48c85f5a2975eff1ea9e943151387b5821bb58
Merge pull request #3087 from peterbe/bug-1223424-drop-adi-count-inclusion-in-the-custom-graphics-report

fixes bug 1223424 - Drop ADI count inclusion in the custom graphics report