Simon Willison’s Weblog

26th September 2023 - Link Blog

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

Qwen 3.8 27B on my laptop can interpret model weights, too - 3rd November 2026
The U.S. Census Bureau and “Super Intelligence” - 2nd November 2026
The October inflection point for vibe game development - 28th October 2026
Battle Drones - a vibe coded RTS with audio-based multiplayer - 20th October 2026

This is a link post by Simon Willison, posted on 26th September 2023.

performance 95 sqlite 489

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