Re:A faster way to copy SQLite databases between computers
by vlovich123 on Thursday May 01, 2025 @04:15PM
(#43862848)
Yup, these results are pretty consistent with what I'd expect (& why I noted the impact of indices) cause even string data has a lot of superfluous information when expressed in the DDL ("INSERT INTO foo ...") - I would expect all of that to exceed any bookkeeping within the btree. And non-string values like blobs or numbers are going to be stored more efficiently than in the dump which is a text encoding (or even hex for blobs) which is going to blow things up further.
[ Parent
| on HN ]
There are no comments on this comment yet.