Neo4j

SimonThordal · 10-04-2022

I am matching a variable length pattern and would like to find the node that is closest in that pattern, so I add a LIMIT 1. If Neo4J searches BFS then I am guaranteed to get the closest result, but I cannot find this in the documentation.The query f...

SimonThordal · 08-19-2022

Does it matter if you put your WHERE predicates next to your MATCH clauses? The other day a colleague asked me if this is a reasonable Cypher query MATCH(p:Person {id:$person_id}) MATCH(doc:Document) MATCH(p)-[:READ]->(doc) WHERE doc.id IN $resource_...

SimonThordal · 04-09-2021

Our database has a string store of 44G and a property store of 14G. We are now trying to reduce the size of the database by removing some unused, text heavy properties, but given this description of how Neo4j treats deleting nodes I have a hard time...

SimonThordal · 01-21-2021

Say you want to search for something like "safety program" but also want to account for "safety programmes" and stemming isn't an option as the indexed documents are in many different languages. The way to do this in Lucene would be with a SpanNearQu...

SimonThordal · 05-18-2020

Under Members -> Query Performance there are two columns called Compile (avg) and Execute (avg). What are the units for these two? I am assuming ms, but without a specified unit it is hard to tell.

SimonThordal · 10-07-2022

Thank you, Luis! I think `shortestPath will do the trick in this case.

SimonThordal · 10-05-2022

Thank you, but this doesn't really answer my question. What I want to know is whether Neo4J matches paths breadth first, depth first or without any guarantee of either. If it is breath first then it should be enough to add the LIMIT 1 clause to my qu...

SimonThordal · 08-22-2022

The query plan does look correct, but my theory is that it is dependent on the graph and that not grouping `MATCH and WHERE is more likely to result in a sub-optimal plan. If not then why would it be in the documentation?

SimonThordal · 04-12-2021

Thanks Dana. Can I just ask once more to be totally clear - deleting nodes, relationships or properties won't change the amount of space used by Neo4J and to reduce the size of the DB we have to use the manual tool, it won't happen on its own like it...

SimonThordal · 04-11-2021

OK, but how about if you only remove large properties and do not delete the nodes. Does that reduce store size or will it stay the same / grow?

Neo4j

User Statistics

User Activity

Does path matching with a LIMIT clause guarantee to find the closest node?

Does it matter if you put your `WHERE` predicates next to your `MATCH` clauses?

Reducing the size of a database by removing node properties

Does FullText indexes support SpanNearQuery

What are the units in Halins Query Performance tab

Re: Does path matching with a LIMIT clause guarantee to find the closest node?

Re: Does path matching with a LIMIT clause guarantee to find the closest node?

Re: Does it matter if you put your `WHERE` predicates next to your `MATCH` clauses?

Re: Reducing the size of a database by removing node properties

Re: Reducing the size of a database by removing node properties