1 Reply Latest reply on Jan 27, 2015 2:14 AM by Horia Chiorean

    Optimized way to count nodes through JCR-SQL2?

    Brett Meyer Apprentice

      Until [MODE-1904] Add support for SQL Count function - JBoss Issue Tracker is finished, any thoughts on an optimized way to count nodes that would result from a JCR-SQL2 query?  In order to support paging, I had hoped to query using LIMIT, but run a second query purely for a total count.  Rather than removing LIMIT and sublisting in-memory, any other recommendations?