nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Get children of a node faster

spilby

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> childRefList = new ArrayList<ChildAssociationRef>();
    childRefList = getNodeService().getChildAssocs(nodeRef);

for (ChildAssociationRef childRef : childRefList) {
    NodeRef nodeChildRef = childRef.getChildRef();
    …
}
‍‍‍‍‍‍‍‍‍‍

But on folders with more than 100 subfolders it takes too long. Are there another quicky way to obtain all direct children of a node? The fastest method you know to do that.

Thanks!

Find more posts tagged with

Comments

spilby

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

(

muralidharand

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

streetturtle

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/

dhartford

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

aweber1nj

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 cmis

bjectId and cmis:name).

Good luck!