How to Optimize a Query with Huge Where Clause

Neo4j Graph Platform Cypher
,
7

I changed some things by removing the filter for isMvp and getting all childs that are sponsored - 2000000 levels downstairs so i would receive more result to see exactly is it faster or not.

MATCH (u:User { userId:"headUserId1232131"})-[:SPONSORED*..2000000]->(child:User)
WHERE child.achievedRank < 1000
  AND child.userId IN ["id1","id2" ... "id1000"] //Here we have 1000 userIds
RETURN child.userId

Thats the profile:

988×939 27 KB

Now the same query, but with your suggestion:

PROFILE
WITH ["id1","id2"..."id10000"] as childList // Here we have the same 1000 users from the upper query
MATCH (u:User { userId:"headUserId142111"})-[:SPONSORED*..2000000]->(child:User)
WITH child, childList
WHERE child.achievedRank < 1000
  AND child.userId IN childList
RETURN child.userId

The profile:

694×1182 35.1 KB

I don't see any improvement with the speed of the query, i`d say is pretty much the same if not even a little slower, but thanks for suggestion. Do you have any other idea?