jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Neale <michael.ne...@gmail.com>
Subject Re: Slow skipping with NodeIterator from Query
Date Fri, 20 Feb 2009 08:19:43 GMT
Ok if I add an order by clause, it works correctly, nice and lazy.

Sent from my phone.

On 20/02/2009, at 17:36, Michael Neale <michael.neale@gmail.com> wrote:

> Actually even if I do SELECT * FROM <nodeType> I still see this.
> Its like it is derserializing each node to inspect it (all on the  
> skip).
>
> I also tried XPath  //element(*, <nodeType>)
>
> It seems the NodeIterator is :
> org.apache.jackrabbit.core.query.lucene.DocOrderNodeIteratorImpl ?
>
> On Fri, Feb 20, 2009 at 5:25 PM, Michael Neale <michael.neale@gmail.com 
> > wrote:
>> Hi all. I have a fairly simple query - the only trap/trick is that it
>> is over a node which has around 10K children. Straight iteration is
>> fine, but when I do a query like:
>>
>> SELECT * FROM <nodeType> WHERE <propertyA>='X' AND  
>> <booleanProperty> = 'false'
>>
>> it runs painfully slow - of the order of 5 minutes to skip(n) (each
>> skip is like that).
>>
>> Is there something deep I am doing wrong?
>>
>
>
>
> -- 
> Michael D Neale
> home: www.michaelneale.net
> blog: michaelneale.blogspot.com

Mime
View raw message