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

    Follow-ups