insert slow

[MrSmallLiu]

Why is batchSize set to 10000 but the insertion is very slow and nearly 100 seconds to complete
thanks

[jingsam]

Many factors could cause insertion slow. Could you provide more details on your issue?

[MrSmallLiu]

I use node-mbtiles to store the tiles of the image, each about 20k, can't do zip compression, set batchsize50000, find the commit transaction in the source code is very slow, about 20 seconds to submit
thanks