https://connect.hyland.com/t5/nuxeo-forum/a-lot-queries-are-performed-on-coresession-getchildren/m-p/327468#M14469 <P>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 <A href="http://answers.nuxeo.com/questions/5899/nuxeo-ep-56-coresessiongetchildren-method-doesnt-work-with-a-type-filter-on-a-base-class" target="test_blank">http://answers.nuxeo.com/questions/5899/nuxeo-ep-56-coresessiongetchildren-method-doesnt-work-with-a-type-filter-on-a-base-class</A> that "getChildren APIs is discouraged because they do not scale".</P> <P>So, my question is that why those queries are not performed in batch (for example 50 items per batch)?</P> Mon, 16 Sep 2013 11:55:02 GMT huionn_ 2013-09-16T11:55:02Z https://connect.hyland.com/t5/nuxeo-forum/a-lot-queries-are-performed-on-coresession-getchildren/m-p/327468#M14469 <P>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 <A href="http://answers.nuxeo.com/questions/5899/nuxeo-ep-56-coresessiongetchildren-method-doesnt-work-with-a-type-filter-on-a-base-class" target="test_blank">http://answers.nuxeo.com/questions/5899/nuxeo-ep-56-coresessiongetchildren-method-doesnt-work-with-a-type-filter-on-a-base-class</A> that "getChildren APIs is discouraged because they do not scale".</P> <P>So, my question is that why those queries are not performed in batch (for example 50 items per batch)?</P> Mon, 16 Sep 2013 11:55:02 GMT https://connect.hyland.com/t5/nuxeo-forum/a-lot-queries-are-performed-on-coresession-getchildren/m-p/327468#M14469 huionn_ 2013-09-16T11:55:02Z