Article - CS270849

Type cache priming performance is poor when a large number of cascading attribute rules are defined in the system

Modified: 11-Jan-2018   


Applies To

  • FlexPLM 11.0 M010

Description

  • Type cache priming performance is poor when a large number of cascading attribute rules are defined in the system
  • Profiler Stacktrace:
O-cost=25846:SELECT 'com.ptc.core.lwc.server.LWCEnumerationBasedConstraint',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.classnamekeyB4,A0.idA3B4,A0.classnamekeyC4,A0.idA3C4,A0.classnamekeydomainRef,A0.idA3domainRef,A0.classnamekeyA5,A0.idA3A5,A0.inheritedDomain,A0.loadID,A0.ruleData,A0.classnamekeyA4,A0.idA3A4,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss') FROM LWCEnumerationBasedConstraint A0 WHERE ((A0.idA2A2 = ?)):count=62034
   O-cost=25846:wt.fc.profiling.SQLExecutionTimeProfilingLogger.addEndEntry(SQLExecutionTimeProfilingLogger.java:103):count=62034
     O-cost=25846:wt.util.TraceTimingCompositeLogger.lambda$addEndEntry$10(TraceTimingCompositeLogger.java:41):count=62034
       O-cost=25846:wt.util.TraceTimingCompositeLogger$$Lambda$37/1343407473.accept(Unknown Source):count=62034
         O-cost=25846:java.util.concurrent.CopyOnWriteArrayList.forEach(CopyOnWriteArrayList.java:890):count=62034
           O-cost=25846:wt.util.TraceTimingCompositeLogger.addEndEntry(TraceTimingCompositeLogger.java:41):count=62034
             O-cost=25846:wt.util.TraceTimingResource.close(TraceTimingResource.java:65):count=62034
               O-cost=25846:wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:626):count=62034
                 O-cost=25846:wt.pds.SQLDatabasePds.refresh(SQLDatabasePds.java:2396):count=62034
                   O-cost=25846:wt.pds.SQLDatabasePds.refresh(SQLDatabasePds.java:2258):count=62034
                     O-cost=25846:wt.pom.PersistentObjectManager.refresh(PersistentObjectManager.java:1477):count=62034
                       O-cost=25846:wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1261):count=62034
                         O-cost=25846:wt.fc.StandardPersistenceManager.restore(StandardPersistenceManager.java:1911):count=62034
                           O-cost=25846:wt.fc.StandardPersistenceManager.refresh(StandardPersistenceManager.java:1083):count=62034
                             O-cost=25846:wt.fc.StandardPersistenceManager.refresh(StandardPersistenceManager.java:517):count=62034
                               O-cost=25846:sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source):count=62034
                                 O-cost=25846:sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):count=62034
                                   O-cost=25846:java.lang.reflect.Method.invoke(Method.java:497):count=62034
                                     O-cost=25846:wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399):count=62034
                                       O-cost=25846:com.sun.proxy.$Proxy10.refresh(Unknown Source):count=62034
                                         O-cost=25846:wt.fc.DefaultInflator$OidCache.inflate(DefaultInflator.java:383):count=62034
                                           O-cost=25846:wt.fc.DefaultInflator$OidCache.inflate(DefaultInflator.java:375):count=62034
                                             O-cost=25846:wt.fc.DefaultInflator$AbstractCache.get(DefaultInflator.java:291):count=62034
                                               O-cost=25846:wt.fc.DefaultInflator$AbstractCache.get(DefaultInflator.java:259):count=62034
                                                 O-cost=25846:wt.fc.DefaultInflator.get(DefaultInflator.java:153):count=62034
                                                   O-cost=25846:wt.fc.ObjectReference.getObject(ObjectReference.java:735):count=62034
                                                     O-cost=25846:com.ptc.core.lwc.server._LWCConstraintConditionLink.getCondition(_LWCConstraintConditionLink.java:69):count=62034
                                                       O-cost=25846:com.ptc.core.lwc.server.cache.AttHelper.getConditionsForConstraint(AttHelper.java:1563):count=62034
                                                         O-cost=25846:com.ptc.core.lwc.server.cache.AttHelper.overrideAtt(AttHelper.java:1332):count=62034
                                                           O-cost=25846:com.ptc.core.lwc.server.cache.AttHelper.translateAttDefsToViews(AttHelper.java:952):count=62034
                                                             O-cost=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.translateTypeDefToView(TypeDefinitionManager.java:2358):count=62034
                                                               O-cost=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.retrieveAndCacheType(TypeDefinitionManager.java:421):count=62034
                                                                 O-cost=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.getTypeDefView(TypeDefinitionManager.java:372):count=62034
                                                                   O-cost=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.ensureAllChildrenAreCached(TypeDefinitionManager.java:2546):count=62034
                                                                     O-cost=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.getChildTypeDefViews(TypeDefinitionManager.java:1455):count=62034
                                                                       O-cost=25846:com.ptc.core.lwc.server.StandardTypeDefinitionService.getChildTypeDefViews(StandardTypeDefinitionService.java:509):count=62034
                                                                         O-cost=25846:sun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source):count=62034
                                                                           O-cost=25846:sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):count=62034
                                                                             O-cost=25846:java.lang.reflect.Method.invoke(Method.java:497):count=62034
                                                                               O-cost=25846:wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399):count=62034
                                                                                 O-cost=25846:com.sun.proxy.$Proxy9.getChildTypeDefViews(Unknown Source):count=62034
                                                                                   O-cost=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:214):count=62034
                                                                                     O-cost=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
                                                                                       O-cost=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
                                                                                         O-cost=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
                                                                                           O-cost=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
                                                                                             O-cost=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.call(TypeCachePrimer.java:104):count=62034
                                                                                               O-cost=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.call(TypeCachePrimer.java:45):count=62034
                                                                                                 O-cost=25846:java.util.concurrent.FutureTask.run(FutureTask.java:266):count=62034
                                                                                                   O-cost=25846:java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):count=62034
                                                                                                     O-cost=25846:java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):count=62034
                                                                                                       O-cost=25846:java.lang.Thread.run(Thread.java:745):count=62034
                                                                                                         '-cost=25846:pool-6-thread-1[SQL+Execution Time+Bind Parameters]:count=62034
 
This is a printer-friendly version of Article 270849 and may be out of date. For the latest version click CS270849