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? XPath:: //*...@sling:resourceType="sakai/group-profile" and jcr:contains(.,'g-test-group')] order by @jcr:score descending JCR-SQL2:: SELECT * FROM [nt:base] as n WHERE [sling:resourceType] = "sakai/group-profile" and contains(n.*,'g-test-group') order by score() desc
