addendum: >select * from [task] where @employeeinchargeid = 3 returns after 90s to 120s
-----Ursprüngliche Nachricht----- Von: Clemens Wyss [mailto:clemens...@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
