Re: Oak query performance problem

2016-10-19 Thread Roy Teeuwen
Hey Thomas Yeah I found that one :) I decided to make my own one to make sure not to run in to trouble when upgrading to a newer version. Thanks for all the info! Greets, Roy > On 19 Oct 2016, at 08:27, Thomas Mueller wrote: > > Hi, > > There is the "nodetype" index (/oak:index/nodetype) whic

Re: Oak query performance problem

2016-10-18 Thread Thomas Mueller
Hi, There is the "nodetype" index (/oak:index/nodetype) which is normally used for such queries. I would change that index. Regards, Thomas On 18/10/16 17:08, "Roy Teeuwen" wrote: >Hey Thomas, > >Ok perfect, laying an oak:QueryIndexDefinition on propertyNames >jcr:primaryType and declaringNod

Re: Oak query performance problem

2016-10-18 Thread Roy Teeuwen
Hey Thomas, Ok perfect, laying an oak:QueryIndexDefinition on propertyNames jcr:primaryType and declaringNodeTypes rep:ACL solved the issue. I presumed there already was an index for all the existing jcr:primaryTypes :), not that you have to specifically have them in the declaringNodeTypes Tha

Re: Oak query performance problem

2016-10-18 Thread Thomas Mueller
Hi, > I really donĀ¹t see the reason why this could be such a hard query Who said it's a hard query? :-) Is the problem performance, or is the problem that you get an exception? If the problem is performance, then you need an index on the node type rep:ACL. If the problem is the exception: In

Oak query performance problem

2016-10-18 Thread Roy Teeuwen
Hello all, I got a problem in oak concerning query performance for the following simple queries SELECT * FROM [rep:ACL] WHERE ISDESCENDANTNODE([/content]) SELECT * FROM [rep:ACL] WHERE ISDESCENDANTNODE([/var]) I get the following exception: java.lang.UnsupportedOperationException: The query