long working method getProperties

[ssmirnov]

hello experts

Can enyone explain me why method getProperties  working so long?

  17.6% - 41,045 ms - 999 inv. com.sun.proxy.$Proxy11.getProperties
       17.6% - 41,028 ms - 999 inv. org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke
           17.5% - 40,872 ms - 999 inv. org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction
                 17.5% - 40,838 ms - 999 inv. org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute
                      17.5% - 40,821 ms - 999 inv. org.alfresco.repo.audit.AuditMethodInterceptor.invoke
                          17.5% - 40,764 ms - 999 inv. org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke
                               17.5% - 40,761 ms - 999 inv. net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke
                                    12.3% - 28,743 ms - 999 inv. org.alfresco.repo.audit.DisableAuditableBehaviourInterceptor.invoke
                                    5.1% - 11,885 ms - 999 inv. net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation
                                    0.1% - 125 ms - 998 inv. net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.afterInvocation

[afaust]

Hello,

not without further information. Have you checked network latency, DB CPU/IO, cache configurations / utilization? What use case are you executing? E.g. if you perform a search without nodes being pre-loaded into caches, and access the properties node-for-node, then you will definitely suffer the full performance impact of X times the roundtrip to DB and processing/conversion of properties. If your nodes have a lot of properties, this will excacerbate matters…

So for any serious help, you need to provide us with more information and may need to perform more measurements to do so…

Regards
Axel