SimpleIdServer
SimpleIdServer copied to clipboard
Performance issue on provisioning thousands of groups and their members in relational databases
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