Possible performance improvement by avoiding Filtering Nodes by Labels?

[clem]

I answer a question about efficiency (see link). What occurs to me, is if Neo4J could keep track of which Relationships have unique incoming and/or outgoing Labels for Nodes, then it could avoid Label filter(s). (This would requiring tracking every Node/Relationship creation, deletion, and modification.)

Efficient Code

I presume you care about the presence/absence of the Labels and not the extra movie title RETURN in A vs. B Here, the PROFILE command will answer your question A) PROFILE MATCH(tom:Person{name:"Tom Hanks"})-[:ACTED_IN]->(mov:Movie)<-[:ACTED_IN]-(co:Person) RETURN co.name // ,mov.title // removed shows 265 total db hits in 120 ms the first time the query is run after restarting the DB. B) PROFILE MATCH (tom:Person {name:"Tom Hanks"})-[:ACTED_IN]->(m)<-[:ACTED_IN]-(coActors) RETURN coActors.…