Hi there, yes, there are performance issues with JCR_SQL2 - see http://wiki.magnolia-cms.com/display/DEV/Queries+in+Jackrabbit+2.4.x for more details. >From our experience the main problem is, that the new JCR Query languages >(JCR_SQL2, JCR_JQOM) are not yet using Lucene sort. As usual the differences >in performance aren't that big with small data sets but can really get huge.
Your query might be much faster when using on of the deprecated languages (JCR_XPATH, JCR_SQL) - the sad truth. In any case you should use setOffset and setLimit wherever possible - will speed up things independently from the Query language. Hope that helps Dan -- Context is everything: http://forum.magnolia-cms.com/forum/thread.html?threadId=c3a0ff14-696c-4c4f-a33b-38bb1a783946 ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
