Loading...

XML

Word

Printable

Steps to Reproduce:

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
Release Note Text:
undefined
Docs QE Status:
NEW
QE Status:
NEW

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.

Search groups / users performance for 500k+ users