jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clemens Wyss <clemens...@mysign.ch>
Subject AW: jcr-sql2 queries "with or without" where-clause :-(
Date Thu, 18 Nov 2010 17:10:42 GMT
addendum:
>select * from [task] where @employeeinchargeid = 3
returns after 90s to 120s

-----Urspr√ľngliche Nachricht-----
Von: Clemens Wyss [mailto:clemensdev@mysign.ch] 
Gesendet: Donnerstag, 18. November 2010 17:56
An: dev@jackrabbit.apache.org
Betreff: jcr-sql2 queries "with or without" where-clause :-(

I know that jcr-sql2 is "in progress". 
Still I would like to know if my oberservations are at all possible:

I have approx. 76'000 [task]-nodes in my repo.

>select * from [task]
takes approx. 870ms, :-)

>select * from [task] order by [jcr:score]
takes btw. 2s and 5s (still somehow "acceptable")

>select * from [task] where employeeinchargeid = 3
Seems to be neverending... I stopped my test after 10minutes! 
employeeinchargeid is a simple int-property. 
The xpath-pendant only takes 311ms, but xpath is deprecated.

Regards
Clemens
Mime
View raw message