/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
Creating and saving many users/principals with relations is slow.
If viewing the JDBC logs the following query can be seen taking a taking a lot of time:
SELECT item_t1.PK FROM pgrels item_t0 JOIN usergroups item_t1 ON item_t0.TargetPK = item_t1.PK
WHERE ( item_t0.Qualifier = ? AND item_t0.SourcePK = ? AND item_t0.languagepk IS NULL)
AND (item_t1.TypePkString IN (?,?,?,?,?) ) order by item_t0.SequenceNumber ASC , item_t0.PK ASC
Read more...
Product
SAP Commerce Cloud 2105 ; SAP Commerce Cloud 2205 ; SAP Commerce Cloud 2211
Keywords
Relationship, PrincipalGroupRelation, hybris , KBA , CEC-SCC-PLA-PL , Platform , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)