数据库插入非常慢

Question

我刚刚从1.4版本升级到2.1.1版本，注意到了一些改进，但插入速度仍然非常慢，随着插入更多文档而变得越来越慢。

我正在从旧数据库迁移到新数据库，每次插入1000个。以下是一些日志供您阅读:

========= [26.28s]
BATCH #1 [0s]
========= [0s]
CREATED: 1000 [0s]
UPDATED: 0 [0s]
SUBTOTAL: 1000 [0s]
BATCH TIME: 26.279s [0s]
TOTAL BATCH TIME: 26.279s [0s]
AVG TIME PER BATCH: 26.279s [0s]
TOTAL TIME: 29.277s [0s]
========= [29.919s]
BATCH #2 [0.001s]
========= [0s]
CREATED: 2000 [0s]
UPDATED: 0 [0s]
SUBTOTAL: 2000 [0s]
BATCH TIME: 29.919s [0s]
TOTAL BATCH TIME: 56.198s [0s]
AVG TIME PER BATCH: 28.099s [0s]
TOTAL TIME: 61.341s [0s]
========= [33.698s]
BATCH #3 [0s]
========= [0s]
CREATED: 3000 [0s]
UPDATED: 0 [0s]
SUBTOTAL: 3000 [0s]
BATCH TIME: 33.697s [0s]
TOTAL BATCH TIME: 89.89500000000001s [0s]
AVG TIME PER BATCH: 29.965000000000003s [0s]
TOTAL TIME: 97.755s [0s]
========= [62.653s]
BATCH #10 [0s]
========= [0s]
CREATED: 10000 [0s]
UPDATED: 0 [0s]
SUBTOTAL: 10000 [0s]
BATCH TIME: 62.653s [0s]
TOTAL BATCH TIME: 438.422s [0s]
AVG TIME PER BATCH: 43.842200000000005s [0s]
TOTAL TIME: 474.096s [0s]

我正在使用ArangoDB NodeJS API并运行以下代码(每批1000次):

db.document.create("users", user)

是否有我在这里错过的东西，或者是ArangoDB失去了任何数据库>1000条记录的原因?

Answer 1

请查看您的集合的属性"waitForSync"。我在waitForSync上有以下经验，创建了1000个文档，并使用了arango的nodejs驱动程序:

<>之前waitForSync true 13.3 s之前<>之前waitForSync false 0,5 s