Slow query performance on filter by date on relationship

Here it is:

MERGE (c:StartDate {date: "2020-05-01"})
CREATE (s:Student {name: "student1"})
CREATE (s1:Student {name: "student2"})
CREATE (q:Question {qstn: "Q1"})
CREATE (q1:Question {qstn: "Q2"})

CREATE (t:StartTime {time: "10:00:00"})
CREATE (t1:StartTime {time: "14:00:00"})

MERGE (c1:StartDate {date: "2020-09-01"})
CREATE (t2:StartTime {time: "14:00:00"})

MERGE (c)-[:STUDENT]->(s)
MERGE (s)-[:START_TIME]->(t)
MERGE (t)-[:ANSWERED]->(q)
MERGE (s)-[:START_TIME]->(t1)
MERGE (t1)-[:ANSWERED]->(q1)

MERGE (c)-[:STUDENT]->(s1)

CREATE (s2:Student {name: "student1"})
CREATE (q2:Question {qstn: "Q3"})
MERGE (c1)-[:STUDENT]->(s2)
MERGE (s2)-[:START_TIME]->(t2)
MERGE (t2)-[:ANSWERED]-(q2)

Added 11 labels, CREATEd 11 nodes, set 11 properties, CREATEd 9 relationships, completed after 803 ms.

You can remove createAt property from :ANSWERED relationship.

Result:

2 Likes