Re: [Neo4j] Performance issue with 2.3.3

2016-06-04 Thread 'Michael Hunger' via Neo4j
Is x a group? And why are there two directions between user and group? With the same rel-type Von meinem iPhone gesendet > Am 04.06.2016 um 14:31 schrieb 'tgomell' via Neo4j : > > In this Special case with a Limit of 20 accounts we have a resultset of 650 > lines. > >

Re: [Neo4j] Performance issue with 2.3.3

2016-06-04 Thread 'tgomell' via Neo4j
In this Special case with a Limit of 20 accounts we have a resultset of 650 lines. profile match (n:i636005417297252034)where n.type='person' with n limit 20 match

Re: [Neo4j] Performance issue with 2.3.3

2016-06-04 Thread 'Michael Hunger' via Neo4j
Also, what's the max distance between a user and a group? what does your domain model look like? why do you have once (:Person)-[:rel_member]->(group) and once (group)-[:rel_member]->(person) ?? why do you need x in between ? you never use it match

Re: [Neo4j] Performance issue with 2.3.3

2016-06-04 Thread 'Michael Hunger' via Neo4j
Please share the EXPLAIN plan This explodes probably into billions or trillions of paths. Some ideas: turn .type properties into labels create a label for all your conditions, e.g. :Process and use those labels instead: What type are M, GG and X ? What is the fan out across those types (min,

[Neo4j] Performance issue with 2.3.3

2016-06-04 Thread 'tgomell' via Neo4j
We have a really complex question: We want to find the ammount of Groups over all paths between all users. >From all User to all User. The Amount of users is 8.000 and the amount of all Groups is 15.000. This cypher request Needs days! Is there a way to make this faster? match