Hello everyone, this is my first post here and I'm kind of new to Neo4j.
I'm trying to get some data from a remotely neo4j database that is running on a single computer. When a run the query on the Neo4j browser it takes approximately 351s to compute, but when I try to run the same query with python using the neo4j driver the query never ends.
Here is the query:
Basically I what to find the users (u2) that tweeted some user (u) in the 'btc' community with the constrain that (u2) are not in the 'btc' community.
match (u:User)-[:IN]->(c:Community{name:'btc'})
where u.final_stock_pagerank > 100
match (u)-[:TWEETED]->(:Tweet)<-[:RETWEETED]-(t:Tweet)<-[:TWEETED]-(u2:User)
where t.timestamp > timestamp() - 2*30*24*3600*1000
and u2.final_stock_pagerank > 100
and not (u2)-[:IN]->(c)
return distinct(u2.username) limit 500
If I change the limit to 350 ( return distinct(u2.username) limit 350
) for example, the query runs fine on 180s, but if I increase the limit values it reaches some threshold and the process just runs forever.
My hypotheses is: If the process takes more than some time X to complete, than something wrong happens and the process never ends.
My configuration is the following:
- neo4j driver version: '1.7.6'
- neo4j : 3.5.15
- I'm using bolt connection (but the problem is the same with http connection )
I also tried to use the py2neo package, but the same problem happens
Thanks!