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 <[email protected]> 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
