This query builds a cartesian product between disconnected patterns. If a part of a query contains multiple disconnected patterns, this will build a cartesian product between all those parts. This may produce a large amount of data and slow down query processing. While occasionally intended, it may often be possible to reformulate the query that avoids the use of this cross product, perhaps by adding a relationship between the different parts or by using OPTIONAL MATCH (identifier is: (to)) match (from:Person{pid:toInteger(line.pid)}),(to:Movie{mid:toInteger(line.mid)}) 请帮我翻译
时间: 2024-02-29 17:57:23 浏览: 455
This is a FFmpeg win32 static build by Kyle Schwarz
这个查询在不相关的模式之间建立了一个笛卡尔积。如果查询的部分包含多个不相关的模式,则会在所有这些部分之间构建笛卡尔积。这可能会产生大量的数据并降低查询处理速度。尽管有时是有意的,但通常可以重新构思查询以避免使用这种交叉产品,例如通过在不同部分之间添加关系或使用OPTIONAL MATCH(标识符为:(to))匹配(from:Person {pid:toInteger(line.pid)}),(to:Movie {mid:toInteger(line.mid)})。
阅读全文