Tuleap Community Edition development and releases are no longer public. You have until September 30th to download packages and sources in Tuleap project. You can contact the team if you need further assistance.

    •  
      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
    13252
    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
    Referenced by request #12541

    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