Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
06-21-2021 12:17 AM
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
06-23-2021 11:51 AM
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
All the sessions of the conference are now available online