Geek Answers Handbook

Slow request neo4j cypher

I am trying to find out why my cypher request is so slow (2-5 seconds for only 5000 nodes). The request tries to find all the tasks that a profile can receive in its network (the work that friends or friends of friends work in one company).

This is the request:

Start current_profile= node:node_auto_index(neoid_unique_id = "Profile:1") Match current_profile-[r:friendships*0..2]->friends-[:roles]->company-[:positions]->jobs return distinct company.fmj_id

I tried clipping the request to see what I am doing wrong, and even this simple request takes too much time:

 START root=node(0) Match root-[:job_subref]->j-[:jobs]->jobss return jobss

Am I doing something wrong?

I use neoid based on non-graphic gem

+6
source share
1 answer

How about this request

 Start current_profile= node:node_auto_index(neoid_unique_id = "Profile:1") Match current_profile-[r:friendships*0..2]->friends WITH friends friends-[:roles]->company-[:positions]->jobs RETURN company.fmj_id
+2
source

More articles:


All Articles