Neo4j之导入CSV大文件 periodic commit

Neo4j之导入CSV大文件 periodic commit

如果要导入包含大量数据的CSV文件，则可以使用periodic commit，默认读取1000行写入一次，也可以设置你想要读取行数参数

using periodic commit
load csv with headers from 'file:///diabetes.csv' as line
create (:Diabetes {
DiabetesPedigreeFunction:line["DiabetesPedigreeFunction"], 
BloodPressure:line["BloodPressure"], 
Outcome:line["Outcome"], 
Glucose:line["Glucose"], 
SkinThickness:line["SkinThickness"],
Insulin:line["Insulin"],
Pregnancies:line["Pregnancies"], 
Age:line["Age"],
BMI:line["BMI"]})

设置200行提交一次，如下：

using periodic commit 200
load csv with headers from 'file:///diabetes.csv' as line
create (:Diabetes {
DiabetesPedigreeFunction:line["DiabetesPedigreeFunction"], 
BloodPressure:line["BloodPressure"], 
Outcome:line["Outcome"], 
Glucose:line["Glucose"], 
SkinThickness:line["SkinThickness"],
Insulin:line["Insulin"],
Pregnancies:line["Pregnancies"], 
Age:line["Age"],
BMI:line["BMI"]})

Well Done