1
Going faster by duplicating code
This function doesn't know the value being multiplied until it is called. The compiler (gcc, O2) emits a generic integer multiply instruction in its loop body.
Abstract Machinist
- Popular posts
- 2
- Total points
- 262
- HN comments
- 95
- Rank
- #10,122 personal
Visit voidstar.tech → On Hacker News Sep 2023 – Oct 2023
Systems & Performance 2Software Engineering 1Databases & Data 1
2
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…