we are using Neo4j with a very generic data model. The particularity is that our Cypher queries need to retrieve nodes of course, but also and especially relationships. I know Neo4j is very fast to retrieve nodes based on paths, but is it good enough when we also need to retrieve the linked relationships to these nodes ?
We have experienced that our Cypher queries can be very fast when we search for thousands of nodes to retrieve, but slower when we also want to retrieve thousands of relationships linked to our nodes. For example, we have a Cypher query which returns around 8 000 nodes and 72 000 relationships. Is there anything we can do to improve the response time of our Cypher queries when we want to return lots of relationships ?
Thanks by advance.