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 #47152 Performance issue on big reports (single value select box)
    Infos
    #47152
    Manuel Vacelet (vaceletm)
    2026-03-06 10:41
    2026-03-03 15:27
    48877
    Details
    Performance issue on big reports (single value select box)

    When loading a big report with many columns with list fields, the number of SQL queries generated might explode (700 lines, 10 columns incl. 4 select values might generate up to 6500 SQL queries).

    The good news is that a large bunch of those queries are not needed because they are already pre-computed in \Tracker_Report_Renderer_Table::fetchTBody.

    Trackers
    Empty
    Empty
    • [x] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    2026-03-06
    Attachments
    By Manuel Vacelet (vaceletm)
    (52 kB)
    image.png
    References
    Referencing request #47152

    Artifact

    request #47154 Performance issue on big reports: multiselect box
    request #47168 Performance issue on big reports

    Git commit

    tuleap/tuleap/stable

    Eliminate O(rows × list_columns) DB queries when rendering tracker report tables 8f9ab8beeb
    User avatar Manuel Vacelet (vaceletm) , 2026-03-06 08:56
    Display settings

    Follow-ups