Bug 1523536 Comment 3 Edit History

Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.

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

```sql
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.name ORDER BY count(bugs.bug_id) DESC LIMIT 10;
```

This is done in 0.00 sec.
Revision 1 by
on 
The `/rest/bug` API call still takes >350ms, which feels slow. We should be adding a new API method to run SQL directly.

```sql
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.

Back to Bug 1523536 Comment 3