In order to enable this feature, add the "-Dorg.exoplatform.jcr.forceUserGetNodesLazily=true" to the java system properties.

The "lazy" iterator reads the child nodes "page" after "page" into the memory. In this context, a "page" is a set of nodes that is read at once. The size of the page is by default 100 nodes and can be configured though workspace container configuration using the "lazy-node-iterator-page-size" parameter. For example:

<container class="org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCWorkspaceDataContainer">

   <properties>

      <property name="source-name" value="jdbcjcr" />

      <property name="multi-db" value="true" />

      <property name="max-buffer-size" value="200k" />

      <property name="swap-directory" value="target/temp/swap/ws" />

      <property name="lazy-node-iterator-page-size" value="50" />

      ...

   </properties>