SimpleIdServer icon indicating copy to clipboard operation
SimpleIdServer copied to clipboard

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

Open antifree opened this issue 7 months ago • 0 comments

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

antifree avatar Jul 06 '24 11:07 antifree