Sunday, 15 July 2012

lucene - Does neo4j auto index work for MATCH clause? -



lucene - Does neo4j auto index work for MATCH clause? -

we have turned on auto indexing both nodes , relationship. default neo4j create index named "node_auto_index" nodes , "relationship_auto_index" relationships. match queries seem under performing (comparing similar info set in elasticsearch). looks not using indexes.

is there way create match clause utilize auto_index ?

we tried looking @ schema index. looks can create node indexes. our queries utilize properties on relationships , hence after using schema index queries unacceptable in performance. there way create schema relationship indexes ?

the node_auto_index not used match, have utilize start clause access legacy index.

e.g.

start user=node:node_auto_index(name="siddarth") match (user)-[:knows]->(friend) homecoming friend

in neo4j 2.0 can create index or unique constraint instead

create index on :user(name);

and utilize in match

match (user:user {name:"siddarth"})-[:friend]->(friend) homecoming friend

see manual: http://docs.neo4j.org/chunked/milestone/query-schema-index.html , cypher refcard: http://neo4j.org/resources/cypher

lucene neo4j

No comments:

Post a Comment