Neo4j 4.3 Relationship Index - A small test

After the release of Neo4j 4.3 on June 17th 2021, I did a small test with a demo dataset.

http://www.dominickumar.com/blog/neo4j-4-3-relationship-index/

Appreciate Neo4j community members to post their performance improvement after upgrading :slight_smile:

2 Likes

I'm a little confused after looking at your results, yes there are 2 less steps, but all the actual detailed numbers, memory, time, dbhits are much higher with 4.3:

+--------------------------------------------------------------------------------------------------------+
| Plan | Statement | Version | Planner | Runtime | Time | DbHits | Rows | Memory (Bytes) |
+--------------------------------------------------------------------------------------------------------+
| "PROFILE" | "READ_ONLY" | "CYPHER 4.2" | "COST" | "PIPELINED" | 3 | 17582 | 1781 | 72 |
+--------------------------------------------------------------------------------------------------------+
vs:
+--------------------------------------------------------------------------------------------------------+
| Plan | Statement | Version | Planner | Runtime | Time | DbHits | Rows | Memory (Bytes) |
+--------------------------------------------------------------------------------------------------------+
| "PROFILE" | "READ_ONLY" | "CYPHER 4.3" | "COST" | "PIPELINED" | 22 | 21127 | 1781 | 136 |
+--------------------------------------------------------------------------------------------------------+

It appears to me that the performance in this case actually got worse? I'm not an expert in Neo4j performance, so I could be wrong and if I am, please explain :slight_smile:

Thanks!
Ryan