"Reverse replication" will have to be set on the Author , it is the author that will poll into the publisher's "outbox" every 5 secs ( configurable ) to read the data.And so is the RR to be configured under "Agents on Author"

"Reverse replication" will have to be set on the Author , it is the author that will poll into the publisher's "outbox" every 5 secs ( configurable ) to read the data.And so is the RR to be configured under "Agents on Author"

Am Sakthi, having various architecture experiences and currently on AEM platform. Interesting to understand the inside of AEM 6.2 and the transitions it undergoes, to help in better solutioning.

I see SQL Query could help in this situation, but how much is it better on performance aspect ?

How to limit the number of nodes returned  using Node.getNodes() in AEM 5.6.1 . or is there any option to travese the child nodes with index ., say Node.getNode(index)., of Node.getFirstChild() ?  This will be helpful in retreiving specific Node by its position, instead of getting all the nodes and ...