•  
      request #6581 Display artifact reverse link performance penalty
    Infos
    #6581
    Manuel Vacelet (vaceletm)
    2014-03-31 11:49
    2014-03-28 13:59
    6650
    Details
    Display artifact reverse link performance penalty
    Display of reverse links does affect platform operation
    mysql> SELECT DISTINCT(tracker_changeset.artifact_id), tracker_artifact.last_changeset_id, tracker.group_id, tracker.item_name AS keyword, tracker.id AS tracker_id FROM tracker_changeset_value_artifactlink AS artlink JOIN tracker_changeset_value as value ON (artlink.changeset_value_id = value.id) JOIN tracker_changeset ON (tracker_changeset.id = value.changeset_id) JOIN tracker_artifact ON (tracker_artifact.id = tracker_changeset.artifact_id) JOIN tracker ON (tracker.id = tracker_artifact.tracker_id) WHERE artlink.artifact_id = 138051 AND tracker_artifact.last_changeset_id = tracker_changeset.id;
    +-------------+-------------------+----------+---------+------------+
    | artifact_id | last_changeset_id | group_id | keyword | tracker_id |
    +-------------+-------------------+----------+---------+------------+
    | 134650 | 328401 | 506 | story | 3498 |
    +-------------+-------------------+----------+---------+------------+
    1 row in set (20.89 sec)
    Trackers
    6.11
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    Empty
    Attachments
    Empty
    References

    Follow-ups