topic Re: Get children of a node faster in Alfresco Archive

Get children of a node faster

spilby — Mon, 17 Aug 2015 21:58:57 GMT

I'm using the alfresco api on my Java backed webscript. I have an uuid, and I do a new NodeRef with this uuid and then I use getChildAssoc from nodeService to obtain all the direct child nodes. NodeRef nodeRef = new NodeRef("workspace://SpacesStore/" + uuid);List<ChildAssociationRef> childRefL

Re: Get children of a node faster

spilby — Thu, 08 Oct 2015 15:00:32 GMT

Any suggestion or idea? I'm still having the problem… (

Re: Get children of a node faster

muralidharand — Fri, 09 Oct 2015 05:21:22 GMT

Hi,
Can you please provide the server H/W & tomcat configuration as well?

Re: Get children of a node faster

streetturtle — Tue, 27 Oct 2015 09:10:42 GMT

Have you tried using CMIS query for that? There is quite interesting possibility to select by path:


select * 
from cmis:document 
where contains('PATH:\"/app:company_home/st:sites/cm:MySite/cm:documentLibrary/cm:MyFolder/*"')
‍‍‍‍‍

You can run this query using

org.alfresco.service.cmr.search.SearchService‍

or a webscript


/share/proxy/alfresco/slingshot/node/search?q=<query>&lang=cmis-alfresco&store=workspace%3A%2F%2FSpacesStore&maxResults=1000
‍‍‍

which is basically the same.

I'm not sure about performance, but I guess it should be slightly better. And you should know exact path to the parent folder.

You can find a bit more info here: http://pavelmakhov.com/2015/10/cmis-path-query/

Re: Get children of a node faster

dhartford — Thu, 29 Oct 2015 16:37:29 GMT

I'll add when using CMIS, there are some options in the OperationContext you can enable/disable/configure that would also make (sometimes significant) performance improvement.

OperationContext usage example: https://chemistry.apache.org/java/examples/example-list-folder.html

Options: https://chemistry.apache.org/java/0.12.0/maven/apidocs/org/apache/chemistry/opencmis/client/api/OperationContext.html

Re: Get children of a node faster

aweber1nj — Fri, 13 Nov 2015 14:29:42 GMT

I don't know if contains is faster for some reason, but CMIS has the IN_FOLDER() clause for this purpose. So if you have the folder's ID it's simply:
<blockcode>select * from cmis:document where IN_FOLDER('folderid')</blockcode>
Also, generally, don't select * when you only need a few properties (like maybe all you need is cmisbjectId and cmis:name).

Good luck!