Hi, I'm using JCR-SQL2 and have hit a strange performance problem. If I do search for something with a ISDESCENDANTNODE in two different paths with two different queries I get results back quickly.
If I now join those two ISDESCENDANTNODE in one query the execution of this query is becoming really really slow. Is there another way to do this or have I found a bug? I'm using jackrabbit 2.4.4 (compiled from SVN-source because I needed the NIOFS/SimpleFS-patch) See this examples: Search in the first path: JCR-SQL2##SELECT * FROM [nt:base] AS document WHERE documentType='xxxxxxxxxxxxxxx' AND CONTAINS(document.name,'hello*') AND ISDESCENDANTNODE(document,'/root/60edd27f-86bc-4f82-8bc0-714ea595823b/libraries/2882ab8e-2d77-4568-adf1-9b0fe3e0b739') Found 3 results Search took 262 ms Search in the second path: JCR-SQL2##SELECT * FROM [nt:base] AS document WHERE documentType='xxxxxxxxxxxxxxx' AND CONTAINS(document.name,'hello*') AND ISDESCENDANTNODE(document,'/root/60edd27f-86bc-4f82-8bc0-714ea595823b/6c6f5fcb-44ae-4407-8da7-d77a2a70c23e') Found 0 results Search took 230 ms Joined query: JCR-SQL2##SELECT * FROM [nt:base] AS document WHERE documentType='xxxxxxxxxxxxxxxxxx' AND CONTAINS(document.name,'hello*') AND (ISDESCENDANTNODE(document,'/root/60edd27f-86bc-4f82-8bc0-714ea595823b/libraries/2882ab8e-2d77-4568-adf1-9b0fe3e0b739') OR ISDESCENDANTNODE(document,'/theTeneoRoot/60edd27f-86bc-4f82-8bc0-714ea595823b/6c6f5fcb-44ae-4407-8da7-d77a2a70c23e')) Found 3 results Search took 161224 ms /Nicklas
smime.p7s
Description: S/MIME cryptographic signature
