2 ms·
Given how sqlite is used, running a hash over a giant (possibly multi-gb file) on startup sounds like a really bad idea.
by bawolff 2y ago
Given how sqlite is used, running a hash over a giant (possibly multi-gb file) on startup sounds like a really bad idea.
- compressedgas 2y agoThe checksums would be on a per page basis. Only the pages of the file that are actually read would be hashed. No need to hash the entire file unless you want to scrub it though this would automatically happen when the database is vacuumed.
- deleted 2y ago[deleted]