CODEWITHSUNDEEP
neo4jneo4jrb
Ferry Phang
Ferry Phang

Reputation: 26

Why my neo4j query insanely slow? How do i improve?

Query Project

Hi I am using neo4j for my production DB with 1800+ for this project node... This is a screenshot from graphenedb on heroku.. Can anybody explain to me how do i improve my query so it didnt taking so long?

Upvotes: 0

Views: 58

Answers (1)

Michael Hunger
Michael Hunger

Reputation: 41706

Very probably you have no index for :Project(status) which causes a full label scan.

Otherwise it should be way less than 1s for only 1800 nodes.

Perhpas it was also the first query after db-start (or suspension) so it had to access disk.

Can you share a PROFILE screenshot of your query?

Upvotes: 2

Related Questions