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