Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
09-28-2020 10:30 PM
Hi all,
I am trying to figure out exactly why there is a difference when returning in a node by itself vs returning all properties from a map projection.
Example:
a)
PROFILE MATCH (g:Group)
OPTIONAL MATCH (g)-[:GROUPS]->(u)
RETURN {group: g, user: collect(u)} AS data
vs
b)
PROFILE MATCH (g:Group)
OPTIONAL MATCH (g)-[:GROUPS]->(u)
RETURN g{.*, user: collect(u{.*})} AS data
I want to know why query (b) takes more memory & a longer execution time compared to query (a)?
Thanks in advance.
All the sessions of the conference are now available online