SQLite improving performance with pre-sort

3 comments

• Loranubi 14 minutes ago
  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.
• gandreani 1 hour ago
  It's not clear in the code how you're batching the writes. Could the performance improvement be mostly explained by batches?
  [-]
• linolevan 1 hour ago
  Neat optimization, I've never seen that before. Thanks for sharing.