Inserting 100k rows 66 times faster

Re:Inserting 100k rows 66 times faster by ak39 on Wednesday March 20, 2024 @08:31AM (#39765508)

Thank you. Also, what database was in use?

[ Parent | on HN ]

Re:Inserting 100k rows 66 times faster by throwaway143829 on Wednesday March 20, 2024 @08:31AM (#39765516)

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

[ Parent | on HN ]

Re:Inserting 100k rows 66 times faster by kikimora on Wednesday March 20, 2024 @09:14AM (#39765982)

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.

[ Parent | on HN ]