a lot queries are performed on CoreSession.getChildren(DocumentRef)
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)?