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 #47154 Performance issue on big reports: multiselect box
    Infos
    #47154
    Manuel Vacelet (vaceletm)
    2026-03-06 13:37
    2026-03-04 09:34
    48907
    Details
    Performance issue on big reports: multiselect box

    In the previous change we were able to re-use a pre-computed value in order to eliminate a bunch of SQL queries.

    For multi-select cases, it's not possible to apply the same approach because 1 artifact might have more than 1 line (due to multiple values). Hence we have to re-query for multi-select values. However we should avoid to re-query each field independently or we will end with O(Nb rows x NB fields with multi-select values).

    The solution is to pre-fetch the values before rendering to lower the number of queries to O(NB fields with multi-select values).

    Timetracking
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Declined
    2026-03-06
    Attachments
    Empty
    References

    Follow-ups