6/26/2026 at 2:36:04 PM
by tosh
6/30/2026 at 12:58:01 AM
It's not clear in the code how you're batching the writes. Could the performance improvement be mostly explained by batches?by gandreani
6/30/2026 at 3:41:29 AM
Looks like he’s doing 1M INSERTs per transaction.In his 2nd example he’s doing the same thing, except he first sorts the data for each of those 1M INSERTs, leading to a 2-3x speedup.
by JSR_FDED
6/30/2026 at 7:20:56 AM
This is not unique to SQLite... it should help with any database that uses B+Trees. Batch deletes are also typically faster when the IDs to be deleted are sorted in these same systems.by rented_mule
6/30/2026 at 1:58:47 AM
Depending on the size of the blob you might not want to use `WITHOUT ROWID`. I had a similar table with uuid keys and blobs of 40kb size on average and `WITHOUT ROWID` really tanked performance.by Loranubi
6/30/2026 at 12:47:32 AM
Neat optimization, I've never seen that before. Thanks for sharing.by linolevan
6/30/2026 at 7:03:10 AM
[flagged]by Abenezer0923
6/30/2026 at 12:38:45 PM
[flagged]by yahavthehackern