Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #17191 Artifacts in trackers with workflow generate way to much SQL requests
    Actions
    Infos
    #17191
    Manuel Vacelet (vaceletm)
    2020-10-19 12:26
    2020-10-09 15:50
    18658
    Details
    Artifacts in trackers with workflow generate way to much SQL requests

    With quite simple workflow (4x4 matrix) we can quickly end up with 1900 SQL queries to display an artifact and 900 queries at update.

    Management of PostActions and esp state based one (hidden & frozen) are quite simple and recompute everything without any form of caching. Let's grab some low hanging fruits and save a tiny part of the forest.

    Trackers
    12.0
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    2020-10-19
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #16652 Tuleap Releases 12.2 Delivered 2020-11-13 14:07 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #17191

    Git commit

    tuleap/tuleap/stable

    Fix performance issue on artifacts with workflow 8ae7e85899
    User avatar Manuel Vacelet (vaceletm) , 2020-10-19 11:53
    Referenced by request #17191

    Artifact Tracker v5

    rel #16652 12.2

    Other

    gerrit #20427
    Display settings

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2020-10-19 12:26
    Integrated into Tuleap 12.1.99.21.
    • Status changed from Under review to Closed
    • Connected artifacts
    • Close date set to 2020-10-19