Neo4j

cypherDMC · 12-11-2019

In our database we have a lot of nodes of type "Document" MATCH (n:Document) RETURN COUNT(n) AS count Returns count 231266485 When queries are made using the operator = the response is fast But we need to search only nodes containing number 8981231...

cypherDMC · 12-12-2019

HI guys We try another approach and works!!! CALL db.index.fulltext.queryNodes('document', '*95587*') yield node AS n WITH n WHERE ((n)-[{someAttribute: 'linkAnalisys'}]-()) RETURN n.number LIMIT 10

cypherDMC · 12-12-2019

Hi mike! thanks for reply Answer the questions Indexes Yes we have indexes in attributes (cpf and "someAttribute") Full Text Search We try use Full text search but the result is the same (slow query) Profile (=) Profile (CONTAINS)

cypherDMC · 12-12-2019

Hi! thanks for reply Sorry for my mistake i just attached the wrong image Explain (Correct) (Type of node is "cpf" i put "Document" to facilitate understanding Profile

Neo4j

User Statistics

User Activity

Slow Cypher Query using CONTAINS and relationships attributes

Re: Slow Cypher Query using CONTAINS and relationships attributes

Re: Slow Cypher Query using CONTAINS and relationships attributes

Re: Slow Cypher Query using CONTAINS and relationships attributes