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 #37239 cross tracker search missing index
    Actions
    Infos
    #37239
    Manuel Vacelet (vaceletm)
    2024-03-26 10:53
    2024-03-26 09:29
    38850
    Details
    cross tracker search missing index

    When doing cross tracker search, the final query join with tracker table to eliminate deleted trackers. However there is no index for that.

    On my enalean.com with 13 trackers involved in a search query (@status = OPEN()) it went from 16s to 0.47s

    Cross tracker search
    development
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    2024-03-26
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #35499 Tuleap Releases 15.7 Delivered 2024-03-28 10:56 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #37239

    Git commit

    tuleap/tuleap/stable

    fix(cross_tracker): Improve cross tracker search query performance bf63e75cf6
    User avatar Manuel Vacelet (vaceletm) , 2024-03-26 10:38
    Display settings

    Follow-ups