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 #31598 (Multi)SelectBox field bound to large list of users (5k+) performance issue
    Actions
    Infos
    #31598
    Manuel Vacelet (vaceletm)
    2023-06-12 14:02
    2023-04-26 09:06
    33201
    Details
    (Multi)SelectBox field bound to large list of users (5k+) performance issue

    Lists with a large amount of users exhibit performance issues. With 6k users:

    • Workflow is checked for each field value (regardless of whether there is a workflow or not). 20k SQL requests.
    • User objects are created one by one (1 sql request per user).
    • On the front end side, the avatar will generate 1 HTTP request per user in the list (auto DoS).

    This affects platforms with large amount of users (5k+) when trackers are using (Multi)SelectBox fields bound to registered_users.

    Trackers
    14.7
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    2023-06-12
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #31538 Tuleap Releases 14.9 Delivered 2023-05-24 15:53 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #31598

    Git commit

    tuleap/tuleap/stable

    fix(perf): there is no transition id when there is no workflow a627ddc938
    User avatar Manuel Vacelet (vaceletm) , 2023-04-27 15:57
    chore(performance): limit query for users in user list field 22aa0e1831
    User avatar Manuel Vacelet (vaceletm) , 2023-05-04 11:49
    chore: Remove non usage of $keyword in tracker list Bind 95f8f4adc6
    User avatar Manuel Vacelet (vaceletm) , 2023-05-09 11:09
    chore: remove useless parameters 82949d552c
    User avatar Manuel Vacelet (vaceletm) , 2023-05-09 13:49
    Display settings

    Follow-ups