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?
