Join the discussion
Write your take first — we'll ask for email only when you're ready to publish.
- Hacker News
- Neat optimization, I've never seen that before. Thanks for sharing.by linolevan
- 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
- 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
- It's not clear in the code how you're batching the writes. Could the performance improvement be mostly explained by batches?by gandreani