Closed Bug 1523536 Opened 2 years ago Closed 1 year ago

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

Categories

(bugzilla.mozilla.org :: API, defect)

Production
defect
Not set
normal

Tracking

()

RESOLVED FIXED

People

(Reporter: glandium, Assigned: kohei.yoshino)

References

(Blocks 1 open bug)

Details

(Keywords: perf)

Attachments

(2 files)

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: 2 years 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
Blocks: 1552433
Type: enhancement → defect
Status: NEW → ASSIGNED
Attached file GitHub Pull Request

Merged to master.

Status: ASSIGNED → RESOLVED
Closed: 2 years ago1 year ago
Resolution: --- → FIXED

This also merged to master.

You need to log in before you can comment on or make changes to this bug.