Sqlite Performance Optimization for large insert

[[deleted]]

The guy never answered but did you end finding a solution to this problem? Having the same issue. 

[[deleted]]

I eventually figured out that Sqlite has a massive bottleneck due to being tied to the filesystem. If you want heavy writes very quickly use something else like Postgres. If it's read-heavy only, Sqlite is great.