[ak39]

Thank you. Also, what database was in use?

[throwaway143829]

sqlite3, but I think bulk inserts would improve perf for other DBs too.

[kikimora]

PG has “copy” which would blow away bulk inserts. Other DB vendors have similar stuff for high-performance inserts. You would be much better off using those than using bulk inserts.

[dopp0]

sqlite