Hello Shaun, Regarding avoiding path constraints queries taking long, you might (will) also win a lot by making the where clause only a little more specific. So, if you keep you where path constraint, but, at the same time, add at you 'category nodes' like '/sport' or '/entertainment' a mixin for this category, you can add element(*,myns:somemix) after your path. This reduces the number of hits before the path constraints have to be accounted for, reducing the number of path constaint lookups a lot.
> > this will probably be faster than a query with a path > constraint, though the memory consumption will stay high. > lucene loads all values of the property to sort by into > memory. depending on the size of the value this results in > quite significant memory usage. If you only sort on date the memory useage for 200.000 nodes shouldn't be to high. Upgrading to the latest released core should also reduce memory useage a lot for queries using an 'order by', certainly when you sort on 'sparse' properties. Regards Ard > > regards > marcel >
