topic Re: Performance Issue of ChildAssocImpl.java (DAO?) in Alfresco Archive

Performance Issue of ChildAssocImpl.java (DAO?)

emil — Mon, 16 Jul 2007 11:16:01 GMT

Hi, authors of Alfresco. I'm using Alfresco 1.4 as a CMS engine of a enterprise application. However, a serious performance issue blocks my solution.I found that it was very slow to create a person in Alfresco when there are hunderds of persons in database. I used some SQL monitoring tool to investi

Re: Performance Issue of ChildAssocImpl.java (DAO?)

derek — Mon, 16 Jul 2007 14:01:00 GMT

Hi,

Have you tried a later version of the product? There were some optimizations in the XPath implementation for 1.4.1 Enterprise. (http://issues.alfresco.com/browse/AR-1114)

Regards

Re: Performance Issue of ChildAssocImpl.java (DAO?)

emil — Tue, 17 Jul 2007 10:04:16 GMT

Hi, thanks for your reply. I found an item (http://issues.alfresco.com/browse/AR-485) in JIRA whose description is similar as my issue, but it was fixed in revision 1.3.
It's so strange…

Re: Performance Issue of ChildAssocImpl.java (DAO?)

derek — Tue, 17 Jul 2007 10:14:24 GMT

Hi,

It's not strange. AR-485 was something that happened all the time in 1.3, i.e. all the children were being populated when one was required - regardless of the mode of access.

Your issue is the AR-1114, which pertains to XPath processing only. The XPath infrastructure was requesting all children and then sorting through them to find the required match.

Regards

Re: Performance Issue of ChildAssocImpl.java (DAO?)

emil — Thu, 19 Jul 2007 10:09:18 GMT

Thanks, I did some test and found that it's better than 1.3 in performance.
But it's OK to migrate my 1.3 data to 1.4.1?

//BR
Emil

Re: Performance Issue of ChildAssocImpl.java (DAO?)

derek — Thu, 19 Jul 2007 10:22:21 GMT

Hi,

Yes. You should upgrade. But go for the latest 1.4 i.e. 1.4.4 Enterprise.

Regards