jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Hall <c...@hallwaytech.com>
Subject Converting XPath to JCR-SQL2
Date Wed, 01 Sep 2010 13:45:15 GMT
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?

//*[@sling:resourceType="sakai/group-profile" and
jcr:contains(.,'g-test-group')] order by @jcr:score descending

SELECT * FROM [nt:base] as n WHERE [sling:resourceType] =
"sakai/group-profile" and contains(n.*,'g-test-group') order by score() desc

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message