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

Status: RESOLVED FIXED

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

Description

[Mike Hommey [:glandium]]

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.

Comment 1

[Kohei Yoshino]

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

Comment 2

[Kohei Yoshino]

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

Comment 3

[Kohei Yoshino]

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.

Comment 4

[Kohei Yoshino]

Attachment: GitHub Pull Request

Comment 5

[Kohei Yoshino]

Merged to master.

Comment 6

[Kohei Yoshino]

Attachment: GitHub Pull Request by Dylan for better performance

This also merged to master.