cancel
Showing results for 
Search instead for 
Did you mean: 

Neo4j 4.3 Relationship Index - A small test

dominicvivek06
Graph Fellow

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

1 REPLY 1

r_moquin
Node Clone

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

Thanks!
Ryan

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.