News for hackers. Stuff that matters.
Re:Inserting 100k rows 66 times faster by throwaway143829 on Wednesday March 20, 2024 @08:27AM (#39765486)
TLDR to get better performance, use bulk inserts instead of inserting one row per query. And (unrelated to DB perf) don't use the spread operator in JS for passing function args (the author says not to use the spread operator at all but you don't need to go that far)
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?
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.
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.