s
Sept. 26, 2023, 5:31 p.m. |

Simon Willison's Weblog simonwillison.net

Batch size one billion: SQLite insert speedups, from the useful to the absurd


Useful, detailed review of ways to maximize the performance of inserting a billion integers into a SQLite database table.


Via Hacker News

billion database hacker performance review sqlite table

Data Engineer

@ Lemon.io | Remote: Europe, LATAM, Canada, UK, Asia, Oceania

Artificial Intelligence – Bioinformatic Expert

@ University of Texas Medical Branch | Galveston, TX

Lead Developer (AI)

@ Cere Network | San Francisco, US

Research Engineer

@ Allora Labs | Remote

Ecosystem Manager

@ Allora Labs | Remote

Founding AI Engineer, Agents

@ Occam AI | New York