corpus.blog
41,554 blogs · 5,316,985 posts Claim your blog
Record · corpus.blog/posts/01a08732-9ca0-70e0-a1f4-33a24bf761af

Towards Inserting One Billion Rows in SQLite Under A Minute

avi.im · published 17 July 2021

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at avi.im Wayback capture
2blogs citing
First cited
24 Jul 2021
Most recent
1 Jan 2024
Rank this month
not ranked
External links
23
Words captured
1,750

Cited by

Blog
In the post
Date
poorlydefinedbehaviour.github.io
Reading list 2023 Read at the source ↗
1 Jan 2024
poorlydefinedbehaviour.github.io
Reading list September 2023 Read at the source ↗
1 Oct 2023
mpweiher
Inserting 130M SQLite Rows per Minute...from a Scripting Language Read at the source ↗
24 Jul 2021

Links from this post

Link
Host
https://github.com/avinassh/fast-sqlite3-inserts
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/f26951ea/naive.py
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/f26951ea/naive_batched.py
github.com
https://www.sqlite.org/pragma.html
sqlite.org
https://remusao.github.io/posts/few-tips-sqlite-perf.html
remusao.github.io
https://stackoverflow.com/Questions/364017/faster-bulk-inserts-in-sqlite3
stackoverflow.com
https://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqlite
stackoverflow.com
https://github.com/the-lean-crate/criner/issues/1
github.com
https://stackoverflow.com/questions/25427769/how-does-executemany-work
stackoverflow.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/3b9850a/sqlite3_opt.py
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/e126bd6/sqlite3_opt_batched.py
github.com
https://www.pypy.org/
pypy.org
https://opencollective.com/pypy
opencollective.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/d27601a/busy_loop.py
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/47fd81f/src/bin/busy.rs
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/bdda921/src/bin/basic.rs
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/ebce33f/src/bin/basic_async.rs
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/cbe53fd/src/bin/basic_prep.rs
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/9cc1ea1/src/bin/basic_batched_wp.rs
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/009694f/src/bin/basic_batched.rs
github.com
https://github.com/avinassh/fast-sqlite3-inserts/blob/bd8414f/src/bin/threaded_batched.rs
github.com
https://twitter.com/iavins
twitter.com
https://github.com/avinassh/cowin-assist
github.com
Elsewhere on avi.im (1)