Abstract Machinist personal blog
Batch size one billion: SQLite insert speedups, from the useful to the absurd
A little-discussed method enables inserting rows with bound data into SQLite faster than any existing technique. This novel method is then discovered to have a drawback that makes it generally unusable. The rest of this article explores how to get the best insert performance out of SQLite generally; what's in your…
- Points
- 104
- HN comments
- 27
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataSystems & Performance2023
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Sep 26, 2023 | Batch size one billion: SQLite insert speedups, from the useful to the absurd by thunderbong | 104 | 27 |
