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.
CoreSession.getChildren(DocumentRef) is used in CMIS Folder.getChildren(...) and I found that multiple SQL are queried on a each child (such as dublincore, acls, misc etc) on first access. It means it will cause a lot of server round-trip for folder with a lot of items. I read from http://answers.nuxeo.com/questions/5899/nuxeo-ep-56-coresessiongetchildren-method-doesnt-work-with-a-type-filter-on-a-base-class that "getChildren APIs is discouraged because they do not scale".
So, my question is that why those queries are not performed in batch (for example 50 items per batch)?