•  
      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
    12588
    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


    Empty
    Trackers
    All
    Empty
    Empty
    Stage
    Marie Ange Garnier (marieange)
    Closed
    2018-11-23
    Attachments
    Empty
    References

    Follow-ups