Hi, On Wed, Sep 1, 2010 at 3:45 PM, Carl Hall <[email protected]> wrote: > Since XPath has been deprecated for searching, I'm working to change over > some XPath queries to JCR-SQL2. I have this one that is killing > performance. Translating the query below to JCR-SQL2 caused a performance > problem (0.072s -> 5s+). > > Am I doing something wrong or is the JCR-SQL2 engine still coming along?
The current JCR-SQL2 implementation is not yet optimized for performance. I'm currently working on improving the JCR-SQL2 implementation, see JCR-2715 [1]. I expect to make JCR-SQL2 query performance comparable to XPath and SQL1 performance in time for the 2.2 release. [1] https://issues.apache.org/jira/browse/JCR-2715 BR, Jukka Zitting
