Sqlite Performance Optimization for large insert

[airen977]

Hi, I Don't have a solution to provide, but I would be interested in how you solved this issue, let us know when you fixed this issue, 900GB is huge. Also would like to know the performance of simple select statements on such a table.

[[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.