Hi All,
I have 3 type of nodes joined with relationship and each node have
heavy set of properties , the total number of nodes are around 20 million
with node store size around 250 MB and property store of size 8GB , however
my queries at this volume are not performing at all , following is the
sample query :-
"Match (a:OTA)-[has_pta]->(b:PTA) where
b.extensions_tenant_statusClass_value_name is not null
and b.extensions_tenant_serviceClass_value_name IN
["support","supWar","warranty"]
with a
Match (a:OTA)-[has_qta]->(d:QTA) where d.amount_normalizedAmount_amount is
not null and
d.amount_normalizedAmount_amount ="10000.0" return count(a);"
I have created index on all the label,property combinations used in the
above query .
I have good 8 core box with 30 GB RAM I have also provided good memory
blocks for memory mapped I/O i.e for node store, relationship store etc .
Please suggest how to scale the query performance further .
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
