2053504 - Need to add index to tracking_flags_values table for better performance from /bzapi/bug and REST search

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: General, enhancement)

Description

[David Lawrence [:dkl]]

Attachment: image.png

SELECT
  `id`,
  `tracking_flag_id`,
  `setter_group_id`,
  VALUE,
  `sortkey`,
  `is_active`,
  COMMENT
FROM
  `tracking_flags_values`
WHERE
  `tracking_flag_id` IN (...)
ORDER BY
  `sortkey`

GCP suggested adding index to tracking_flag_id column which will help with look ups

Comment 1

[David Lawrence [:dkl]]

Attachment: image.png

Comment 2

[BMO Github Automation]

Attachment: [mozilla-bteam/bmo] Bug 2053504 - Need to add index to tracking_flags_values table for better performance from /bzapi/bug and REST search (#2665)

Comment 3

[BMO Github Automation]

Authored by https://github.com/dklawren
https://github.com/mozilla-bteam/bmo/commit/0fe42d6b34f3e06254b3c78ded84958ae7efd8cd
[master] Bug 2053504 - Need to add index to tracking_flags_values table for better performance from search