Neo4j

Bertel · 12-07-2022

I've been trying to run some read queries concurrently using asyncio tasks and gather(). I've tried to run the queries concurrently within a transaction. session and driver, but they all fail. Does anyone have an idea on how to run multiple read quer...

Bertel · 11-29-2022

I discovered today that alias length can affect query in a huge way. I'm doing a count query with some date filters, with indexes on date property (NodeIndexSeekByRange). Profiling this query i discovered that using an alias with 4 or less charact...

Bertel · 01-23-2023

Changing predicate order again seems to fix the problem so that n.date2 index is seeked first. Though this query feels unreliable to me, since I don't really understand the query planner decisions, and can't find any docs on it. MATCH (n:Node) WHE...

Bertel · 01-23-2023

I am having issues again with this query MATCH (n:Node) WHERE (datetime($date1) > n.date1 AND datetime($date2) < n.date2) OR (datetime($date1) <= n.date1 <= datetime($date2) OR datetime($date1) <= n.date2 <= datetime($date2)) RETURN COUNT(*) AS c...

Bertel · 12-08-2022

Hi, that example shows running a single query. I want to run multiple read queries in a for-loop concurrently, preferably within the same transaction. Do you have an example of this?

Bertel · 12-07-2022

Conditional cypher execution with subqueries might be of interest if you want to optimize the query: https://neo4j.com/developer/kb/conditional-cypher-execution/

Bertel · 11-30-2022

After some more digging it seems that this is related to predicate order in the where statement. My original query was something like this: MATCH (n:Node) WHERE (datetime($date1) <= n.date1 <= datetime($date2) OR datetime($date1) <= n.date2 <= datet...

Neo4j

User Statistics

User Activity

Neo4j python driver with asyncio.gather() crashes

Cypher: Alias length >4 chars makes query 25x slower

Re: Cypher: Alias length >4 chars makes query 25x slower

Re: Cypher: Alias length >4 chars makes query 25x slower

Re: Neo4j python driver with asyncio.gather() crashes

Re: how create cypher query with conditional filters

Re: Cypher: Alias length >4 chars makes query 25x slower