PRAGMA page_size 65536 | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

malkia on July 19, 2021 | parent | context | favorite | on: Inserting a billion rows in SQLite under a minute

PRAGMA page_size 65536

malkia on July 19, 2021 [–]

But ensure this is actually in effect (e.g. do vacuum, etc.)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact