•  
      request #12541 Edition of a selectbox might be long
    Infos
    #12541
    Marie Ange Garnier (marieange)
    2018-11-23 10:05
    2018-11-21 13:52
    13248
    Details
    Edition of a selectbox might be long
    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:
    Handler_read_first 1
    Handler_read_key 7
    Handler_read_last 0
    Handler_read_next 213


    Trackers
    All
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Marie Ange Garnier (marieange)
    Closed
    2018-11-23
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    This should be enough, I close the artifact.

    • Status changed from Under implementation to Closed
    • Close date set to 2018-11-23