jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicklas Löf <nicklas....@artificial-solutions.com>
Subject Strange search performance
Date Wed, 13 Feb 2013 16:23:49 GMT
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
Mime
View raw message