New bug's "Choose from your most-used components" list is slow to show up

RESOLVED FIXED

Status

()

defect
RESOLVED FIXED
5 months ago
Last month

People

(Reporter: glandium, Assigned: kohei)

Tracking

(Blocks 1 bug, {perf})

Production
Dependency tree / graph

Firefox Tracking Flags

(Not tracked)

Details

Attachments

(2 attachments)

Reporter

Description

5 months ago

The list of most-used components that shows up on the new bug page is really useful, but it's so slow to show up that I can type something in the find box and get the corresponding autocompletion before it's filled up.

Yeah I know, the /rest/bug API is really slow. Will find a better way to do it once I get time.

Component: General → Extensions: BMO
See Also: → 1473417

Dylan has just fixed Bug 1512815, so the component list is now displayed quickly. The fix will be deployed tomorrow \o/

Status: NEW → RESOLVED
Closed: 5 months ago
Depends on: 1512815
Keywords: perf
Resolution: --- → FIXED

The /rest/bug API call still takes >350ms, which feels slow. We should be adding a new API method to run SQL directly.

SELECT products.name AS product, components.name AS component FROM bugs
INNER JOIN products ON bugs.product_id = products.id
INNER JOIN components ON bugs.component_id = components.id
WHERE bugs.reporter = 232883 AND bugs.creation_ts > '2018-05-17'
  AND products.isactive = 1 AND components.isactive = 1
GROUP BY components.id ORDER BY count(bugs.bug_id) DESC LIMIT 10;

This is done in 0.00 sec.

Assignee: nobody → kohei.yoshino
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Status: REOPENED → NEW
Component: Extensions: BMO → API
Type: enhancement → defect
Status: NEW → ASSIGNED

Merged to master.

Status: ASSIGNED → RESOLVED
Closed: 5 months agoLast month
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.