cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Difference between pure cypher and a APOC alternative

Are there any performance differences running these to queries? Assuming the label always staying the same will the query planner perform nearly identical because the Statement get translated internaly to nearly the same?

UNWIND {batch} as row
CREATE (n:Test {row.properties})
RETURN count(*)
UNWIND {batch} as row
CALL apoc.create.node([row.label], row.properties) yield node
RETURN count(*)
2 REPLIES 2

Add the clause PROFILE at the beginning of each query as the first line you will have your answer. You can use EXPLAIN clause too to avoid the actual execution of the query again but you wont have every details.

Done that, but i´m not really sure how to interpret the plans correctly.
Does it mean that the APOC version is even faster than the pure cypher because it has less DB hits?

Cypher Create:

APOC Create