Cypher neo4j-在集合上使用子句'in'的查询非常慢

Question

1. 键->字符串
2. principal_name->string
3. 别名->字符串集合
4. .......

我还在principal_name、别名和key上添加了索引。

当我试图导入Article类型节点和Author类型节点之间的关系时，问题就出现了。

articleKey,authorName

USING PERIODIC COMMIT 1000
LOAD CSV WITH HEADERS FROM "file:///myPath.csv" AS line
MATCH (art:Article{key: line.key1})
MATCH (auth:Author) WHERE line.key2 IN (auth.alias)
CREATE UNIQUE (auth)-[:AUTHOR_OF]->(art);

MATCH (auth:Author{principal_name: line.key2})
IF auth null THEN
  MATCH (auth:Author) WHERE line.key2 IN (auth.alias)
END

有办法用Cypher做到这一点吗？

Answer 1

如果更改了模型，使author节点的所有名称（主体名称和所有别名）都位于单独的name节点中，如下所示：

(auth:Author)-[:HAS_NAME]->(name:Name {name: 'Fred McGillicutty'})

那么查询将是：

USING PERIODIC COMMIT 1000
LOAD CSV WITH HEADERS FROM "file:///myPath.csv" AS line
MATCH
  (art:Article { key: line.key1 }),
  (auth:Author)-[:HAS_NAME]->(name:Name { name:line.key2 })
CREATE (auth)-[:AUTHOR_OF]->(art);

如果在:article(key)和:name(name)上创建索引，该查询应该非常高效。