•  
      request #37239 cross tracker search missing index
    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
    Empty
    References
    Referencing request #37239

    Follow-ups