One Customer is complaining the performance, and from there AWR , found that there are two SQLS are very slow.
select j.*, t1.mxPhysicalId, t1.mxLogicalId, t1.mxCEStamp, t1.mxUpdateStamp, t1.mxTenant, t1.mxMajorId, t1.mxVersionId, t1.mxMinorOrder, t1.mxMajorOrder, t1.mxPublished, t1.lxKind, t1.mxIsBSF from (select * from lxRO_9269f943 where (lxType in (:va))) j left outer join mxIdent t1 on j.lxOid=t1.lxOid and t1.mxLattice=:vb
select j.*, t1.mxPhysicalId, t1.mxLogicalId, t1.mxCEStamp, t1.mxUpdateStamp, t1.mxTenant, t1.mxMajorId, t1.mxVersionId, t1.mxMinorOrder, t1.mxMajorOrder, t1.mxPublished, t1.lxKind, t1.mxIsBSF from (select * from lxRO_8f824824 where (lxType in (:va))) j left outer join mxIdent t1 on j.lxOid=t1.lxOid and t1.mxLattice=:vb
This is because 3DEXPERIENCE CATIA version before 2022x FD01, there will be two functions have performance issue when data size is big. checklist for close the two function:
1./ We need to make sure there is no static mapping
Please run the following MQL and provide the output
eval expr COUNT(true) on temp query bus VPMCfgInstanceConfiguration * *;
2./We need to make sure anyway that there is no composition matrix
Please run the following MQL and provide the output
query connection type “Child Composition Binary” limit 1 select physicalid;
query connection type “Parent Composition Binary” limit 1 select physicalid;
query connection type “Manufacturing Plan Breakdown” limit 1 select physicalid;
Based on the MQL output R&D will provide variable with correct parameter values to improve the performance.
3./We need to know if Customer is using the following functionalities:
– “Insert Product Configuration” (Native Application, Dashboad-Enginerring Release)
– “Add Composition Matrix” (WebApplications-Variant Management
if there is no data and customer is not using two function. then we can execute following MQL to close the two functions and improve performance.
add expression CompositionMatrixActivation value NoCompositionMatrix;
add expression StaticMappingActivation value NoStaticMapping;after executing the two MQL, the two function is closed, and performance will back to normal.
Note that the MQLs is only for old version. From 22x FD01 , there is settings on Space Configuration Center , do not use MQL then.
