search

simpleidserver / SimpleIdServer

OpenID, OAuth 2.0, SCIM2.0, UMA2.0, FAPI, CIBA & OPENBANKING Framework for ASP.NET Core
https://simpleidserver.com/
Apache License 2.0
735 stars 99 forks source link

Performance issue on provisioning thousands of groups and their members in relational databases #773

Open antifree opened 4 months ago

antifree commented 4 months ago

Hello @simpleidserver!

We faced a performance issue when provisioned more that 100k+ groups and their members. In this case we have more than15 mil records in SCIMRepresantationAttrList.

But the database is loaded up to 100% and cannot perform an adding a group member since sql requests use in WHERE clause fields FullPath and ValueString that are not indexed.

I'll prepare an MR to add indexes