neo4j-加载到图形需要太多时间

Question

CUSTOMER_UNIQUE_ID (Customer Code)
ORDER_ID (Order Code)
ORDER_DATE (Order date)
CLIENT_TYPE (Ordered via Mobile / App / Desktop)
PARENT_SKU (Product ID)
LEV1 (Category Level 1)
LEV2 (Category Level 2)
LEV3 (Category Level 3)

USING PERIODIC COMMIT 1000
LOAD CSV WITH HEADERS FROM "FILE:///E:/Data/2015/Nov/MBA/order_item_MBA.csv" AS line
MERGE(product:Product {parent_sku:line.PARENT_SKU}) ON CREATE SET product.parent_sku = line.PARENT_SKU, product.lev1 = line.LEV1, product.lev2 = line.LEV2, product.lev3 = line.LEV3

Answer 1

如果在节点上merge，则应该在属性上有一个索引(http://neo4j.com/docs/stable/query-schema-index.html):

CREATE INDEX ON :Product(parent_sku)

理想情况下，您在此标签上为此属性创建一个唯一性约束。这将自动添加一个非常快速的索引(http://neo4j.com/docs/stable/query-constraints.html):

CREATE CONSTRAINT ON (node:Product) ASSERT node.parent_sku IS UNIQUE

这将大大加快您的导入速度。