Hi Michael, sorry for the late reply. Yes, it was a memory issue and has been resolved.
On Monday, July 6, 2015 at 1:07:05 AM UTC+2, Michael Hunger wrote: > > the query looks ok to me. > > do you have any memory constraints on your server? > > could you by chance share your original graph? > > Thanks Michael > > Am 04.07.2015 um 23:59 schrieb Markus Hofer <[email protected] > <javascript:>>: > > The following query works, inserting 5000 nodes and relationships in 3 > seconds > > MATCH >> (n:Contact)--(:ActivityContact)--(ar:ActivityReport)--(:ActivityContact)--(nn:Contact) >> WHERE n <> nn >> WITH DISTINCT n, COUNT(ar) AS value >> CREATE (s:ScoreFactor { >> name: "MeetingContactFrequency1", >> rawvalue: value >> }) >> CREATE (n)-[:HasScoreFactor]->(s) > > > For some reason this query does not work. Although it matches 11000 > distinct (n), it runs endlessly without creating any nodes. Server load is > 100%. > > MATCH >> (n:Contact)--(:ActivityContact)--(ar:ActivityReport)--(:ActivityUser)--(:User) >> WITH DISTINCT n, COUNT(ar) AS value >> CREATE (s:ScoreFactor { >> name: "MeetingContactFrequency2", >> rawvalue: value >> }) >> CREATE (n)-[:HasScoreFactor]->(s) > > > -- > 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] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > > -- 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.
