logoalt Hacker News

SQLite improving performance with pre-sort

48 pointsby toshlast Friday at 2:36 PM4 commentsview on HN

Comments

gandreanitoday at 12:58 AM

It's not clear in the code how you're batching the writes. Could the performance improvement be mostly explained by batches?

show 2 replies
Loranubitoday at 1:58 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.

linolevantoday at 12:47 AM

Neat optimization, I've never seen that before. Thanks for sharing.