Relation Query very Slow

[cbelka]

The Query

SELECT PK,TargetPK,SourcePK,SequenceNumber,RSequenceNumber FROM pgrels WHERE SourcePK IN (?) AND languagepk IS NULL  UNION SELECT PK,TargetPK,SourcePK,SequenceNumber,RSequenceNumber FROM pgrels WHERE TargetPK IN (?) AND languagepk IS NULL

during guestcheckout is getting very very slow because it gets nearly the whole customer database when adding the customer to the customergroup during checkout.

It gets generated from the "ModifyManyToManyRelationStatementsBuilder" ... I remebered that from old versions the flag "relation.PrincipalGroupRelation.markmodified" did help there but I might be wrong ... can anyone help here ?

SAP Commerce 1811 is our version

[Former Member]

We seem to have the same issue in our implementation. Our SAP Commerce version is 6.7.

Were you able to find a solution to this problem?

[Former Member]

Christian - How do we implement your suggestion of "use legacy mode not globally but for saving this single transaction" ?

Thanks in advance for your help.

[former_member710842]

Hello cssidhu, We are facing the same issue in v2005. Any suggestions please?

[cbelka]

yeah you can use legacy mode not globally but for saving this single transaction ... There is a Util for that , with legacy mode you dont have this problem

[former_member710842]

Hello cbelka, We are facing the same issue in v2005. Could you please explain which legacy mode u r talking about for the transaction?

[cbelka]

Yes as I mentioned, identify the query (update etc) and then run it in legacy mode

PersistenceUtils.doWithLegacyPersistence(() -> {
    doSlowStuff(modelWithLotsOfRelations);
    modelService.save(modelWithLotsOfRelations);
    return null;
});

[pavan_joshi1]

Oh.. Interesting! I want to try this sometime.