Closed Bug 1394468 Opened 7 years ago Closed 7 years ago

re:dash (sql.telemetry.mozilla.org) *very* slow on nightly

Categories

(Data Platform and Tools :: General, defect)

defect
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: frank, Unassigned)

Details

We have a profile here: http://bit.ly/2wG1Qz5
That 2885ms DOMEvent part looks maybe-interesting? 710ms GCMajor in there too.
Flags: needinfo?(bugs)
Product: Chat Core → Core
Version: trunk → Trunk
DOMEvent here means just that we run some very heavy JS in a load event listener.
I don't see 710ms major GC anywhere. It is a major GC which has several slices and time between the first and last is 710ms.

What is the website doing when loaded?
Flags: needinfo?(bugs)
oh, is it XHR's load event, not page's.
The profile seems to miss some proper symbols.
(In reply to Olli Pettay [:smaug] from comment #2)
> DOMEvent here means just that we run some very heavy JS in a load event
> listener.
> I don't see 710ms major GC anywhere. It is a major GC which has several
> slices and time between the first and last is 710ms.
> 
> What is the website doing when loaded?

This was captured while inputting text into the editor, a short one line query followed by submitting the result.
I ran the mozregression tool to test if this were a firefox regression starting on 2017-07-01. I get consistently poor performance going back in nightly, but the tool has run fine in the last few weeks.
I see the same poor behavior on Chrome, this is a redash issue.
Moving this since we have confirmed this is a re:dash issue.
Component: General → Redash (STMO)
Product: Core → Data Platform and Tools
Version: Trunk → unspecified
I'll mention for the sake of mentioning that there could still a Firefox perf win to be had here, even if it was a re:dash change that made things worse.
I haven't noticed any major performance pain using STMO in nightly recently. Is this still happening for you Frank?
Flags: needinfo?(fbertsch)
Yup, this was fixed in re:dash at some point :)
Status: NEW → RESOLVED
Closed: 7 years ago
Flags: needinfo?(fbertsch)
Resolution: --- → FIXED
Component: Redash (STMO) → General
You need to log in before you can comment on or make changes to this bug.