•  
      request #31941 Aggregate query is always run
    Infos
    #31941
    Manuel Vacelet (vaceletm)
    2023-05-16 11:31
    2023-05-15 15:49
    33528
    Details
    Aggregate query is always run

    When rendering a tracker report with a table that contains a field that can be aggregated (eg a Selectbox), the aggregate query is always run even when there is no aggregation on the said column.

    In trackers with very large number of artifacts (10k+) that can lead up to 50% of the rendering time for nothing. The query is long because it's heavy (all the matching ids are passed around) and more important useless because we already know there won't be any results.

    Trackers
    14.8
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    2023-05-16
    Attachments
    Empty
    References

    Follow-ups