As tracker administrator, have a selectbox bound to many statics values Slow query SELECT IF(v.original_value_id, v.original_value_id, v.id) AS id FROM tracker_field_list_bind_static_value AS v INNER JOIN tracker_changeset_value_list AS cvl ON (v.id = cvl.bindvalue_id) INNER JOIN tracker_changeset_value AS cv ON (cv.id = cvl.changeset_value_id AND cv.field_id = v.field_id) WHERE v.field_id = ? UNION SELECT v.id AS id FROM tracker_field_list_bind_static_value AS v INNER JOIN tracker_changeset_value_openlist AS cvl ON (v.id = cvl.bindvalue_id) INNER JOIN tracker_changeset_value AS cv ON (cv.id = cvl.changeset_value_id AND cv.field_id = v.field_id) WHERE cv.field_id = ? UNION SELECT tracker_workflow_trigger_rule_static_value.value_id FROM tracker_workflow_trigger_rule_static_value WHERE tracker_workflow_trigger_rule_static_value.value_id = ? UNION SELECT tracker_workflow_trigger_rule_trg_field_static_value.value_id FROM tracker_workflow_trigger_rule_trg_field_static_value WHERE tracker_workflow_trigger_rule_trg_field_static_value.value_id = ?; Associate handler without the indexes: Handler_read_first 2 Handler_read_key 26928 Handler_read_last 0 Handler_read_next 59510 Handler after indexes: Handler_read_first 1 Handler_read_key 2686 Handler_read_last 0 Handler_read_next 2693 Change-Id: I8ca4d192ce176487e78e49fb17a95056b2256752

+59 −5

Author

Marie Ange Garnier (marieange) 2018-11-21 14:04

Committer

Marie Ange Garnier (marieange) 2018-11-22 12:07

Hash c17b9bc666b8ab454ba29299c739170d872f92e6

Parent a28210b39e4a3348fa874b7c20e057f28e65327d

Reference git #tuleap/stable/c17b9bc666b8ab454ba29299c739170d872f92e6