Simon Willison’s Weblog

Batch size one billion: SQLite insert speedups, from the useful to the absurd (via) Useful, detailed review of ways to maximize the performance of inserting a billion integers into a SQLite database table.

Posted 26th September 2023 at 5:31 pm

Recent articles

Useful patterns for building HTML tools - 10th December 2025
Under the hood of Canada Spends with Brendan Samek - 9th December 2025
Highlights from my appearance on the Data Renegades podcast with CL Kao and Dori Wilson - 26th November 2025

performance 93 sqlite 306

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe