技术文章 - CS270849
系统定义大量级联属性规则时类型缓存启动性能差
已修改: 22-Dec-2022
适用于
- FlexPLM 11.0 M010
说明
- 系统定义大量级联属性规则时类型缓存启动性能差
- 探查器堆栈跟踪:
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-成本=25846:wt.util.TraceTimingCompositeLogger.lambda$addEndEntry$10(TraceTimingCompositeLogger.java:41):count=62034
O-cost=25846:wt.util.TraceTimingCompositeLogger$$Lambda$37/1343407473.accept(未知来源):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-成本=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(未知来源):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(未知来源):count=62034
O-成本=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-成本=25846:com.ptc.core.lwc.server._LWCConstraintConditionLink.getCondition(_LWCConstraintConditionLink.java:69):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.AttHelper.getConditionsForConstraint(AttHelper.java:1563):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.AttHelper.overrideAtt(AttHelper.java:1332):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.AttHelper.translateAttDefsToViews(AttHelper.java:952):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.translateTypeDefToView(TypeDefinitionManager.java:2358):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.retrieveAndCacheType(TypeDefinitionManager.java:421):count=62034
O-成本=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-成本=25846:com.ptc.core.lwc.server.cache.TypeDefinitionManager.getChildTypeDefViews(TypeDefinitionManager.java:1455):count=62034
O-成本=25846:com.ptc.core.lwc.server.StandardTypeDefinitionService.getChildTypeDefViews(StandardTypeDefinitionService.java:509):count=62034
O-cost=25846:sun.reflect.GeneratedMethodAccessor262.invoke(未知来源):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(未知来源):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:214):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.getDescendantTypes(TypeCachePrimer.java:232):count=62034
O-成本=25846:com.ptc.core.lwc.server.cache.TypeCachePrimer.call(TypeCachePrimer.java:104):count=62034
O-成本=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+执行时间+绑定参数]:count=62034
这是文章 270849 的 PDF 版本,可能已过期。最新版本 CS270849