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 06:36:30 GMT
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

View raw message