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