Uploaded image for project: 'Keycloak'
  1. Keycloak
  2. KEYCLOAK-19129

Search groups / users performance for 500k+ users

    XMLWordPrintable

Details

    • Hide

      Create a database and fill it with 500k users.

      Also create 100 groups and but ten members in each group.

      Call the endpoints above

      Show
      Create a database and fill it with 500k users. Also create 100 groups and but ten members in each group. Call the endpoints above
    • NEW
    • NEW

    Description

      After upgrading from 8.0.0 we discovered major performance issues when searching for both groups and users in databases with 500k+ users.

      Before the upgrade, a search took around 100ms, after the upgrade we have the following numbers:

       /{realm}/users?search=QUERY - *15.5s

       /{realm}/groups?search=QUERY - *7.4s

       

      **It is also super slow to fetch the members of a group by calling

       /{realm}/groups/{id}/members - *6s

       

      I think an index might be missing. 

      Attachments

        Activity

          People

            sguilhen Stefan Guilhen
            mr.axelander Alexander Najafi (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: