SQLite improving performance with pre-sort

 (andersmurphy.com)

43 points | by tosh 3 days ago

3 comments

  • gandreani 2 hours ago
    It's not clear in the code how you're batching the writes. Could the performance improvement be mostly explained by batches?
    [-]
    • JSR_FDED 11 minutes ago
      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.

  • Loranubi 1 hour 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.
  • linolevan 3 hours ago
    Neat optimization, I've never seen that before. Thanks for sharing.