Re:A faster way to copy SQLite databases between computers
by pnm45678 on Thursday May 01, 2025 @07:20PM
(#43864460)
It all depends what you’re optimizing for.
Clearly, when you don’t transfer indexes, you will not have to transfer as much data.
However, the tradeoff is that the database is going to have to do more work to regenerate those indexes when you reconstruct it from the text dump at the destination (as opposed to the case where the indexes were included)
Clearly, when you don’t transfer indexes, you will not have to transfer as much data.
However, the tradeoff is that the database is going to have to do more work to regenerate those indexes when you reconstruct it from the text dump at the destination (as opposed to the case where the indexes were included)