Avoid cycles in Cypher queries

[zakjan]

Hi all,

I have published a new blogpost. When writing Cypher queries, be sure that it don't match any cycles, or you can experience unpleasant surprises.

I'd be happy for your review.

https://graphaware.com/neo4j/2019/04/26/avoid-cycles-in-cypher-queries.html

[ryan_boyd]

Fantastic - thanks so much for writing this Jan and for sharing on the community!

I think the suggestion about searching for explicit directions (and bounded nodes/relationships) is extremely important to avoid this condition. Perhaps in the future we can provide feedback to people when they execute a query which traverses a lot between the same two nodes.

Cheers,
-Ryan

[zakjan]

Hi @ryan.boyd, thanks for the appreciation! I'm wondering how could Neo4j provide such feedback? It could be useful prior starting the query, in case the query would run for very long time or even never finish.

[greta]

Thanks for submitting!

I've added a tag that allows your blog to be displayed on the community home page!