Hello,
I have two labels (commits and users).
In the commits I have the ID of the committer as Int (committer-id).
I want to create a simple relationship between the committer and the user (u.id).
My solution looks like this:
match(c:commits)
with c
match(u:users)
where c.committer_id = u.id
create(c)-[:committer]->(u)
My current problem is that is takes a long time to create this relationship.
I added an index the committer_id, but it didn't improve my query.
Any Idea of improvements?
Constraints:
Settings:
dbms.memory.heap.initial_size=8G
dbms.memory.heap.max_size=8G
dbms.memory.pagecache.size=5G